Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_JOBS

Re: DBMS_JOBS

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 23 Nov 2006 23:40:50 -0800
Message-ID: <1164354050.794227.270680@j72g2000cwa.googlegroups.com>


Gowree ha escrito:

> Jim,
>
> You are right
>
> if the job_queue_processes.=0, then it wont run
> i found out from one of the DBA.
> Thanks a lot for ur time.
> Now the job is working fine.
>
> do you think if i changed this job_queue_processes.=10 this will affect
> other programs in oracle server.
>
>
> Jim Smith wrote:
> > In message <1164230597.888210.196630_at_f16g2000cwb.googlegroups.com>,
> > Gowree <gowreesan_at_gmail.com> writes
> > >Jim,
> > >when i select the
> > >'select * from user_jobs'
> > >it display the job # and next date,next sec,total time =0 and broken=N.
> > >interval as trunc(sysdate+1/144,'MI')
> > >
> > >
> > I assume last_date is null, implying the job has never run?
> >
> > Try "show parameter job" in sqlplus.
> >
> >
> > This should show the setting for job_queue_processes. If this is 0, then
> > jobs will not run.
> > >Jim Smith wrote:
> > >> In message <1164221305.683722.284960_at_h48g2000cwc.googlegroups.com>,
> > >> Gowree <gowreesan_at_gmail.com> writes
> > >> >
> > >> >Carlos,
> > >> >This is a simple script which invoke the database every 15 min and
> > >> >insert into temp table.
> > >> >Forgot about the previous one....i just trying to do this simple one
> > >> >but it's not working
> > >> >This PL/SQL statement compiled with any error but it's not running the
> > >> >job
> > >> >
> > >> >declare
> > >> >
> > >> > x1 number;
> > >> >
> > >> >BEGIN
> > >> >
> > >> > DBMS_JOB.SUBMIT(
> > >> > x1,
> > >> > 'job1;' ,
> > >> > TRUNC(SYSDATE+1/144,'MI') ,
> > >> > 'trunc(sysdate+1/144,''MI'')'
> > >> >
> > >> >);
> > >> >
> > >> > commit;
> > >> >
> > >> >END;
> > >> >
> > >> What does 'select * from user_jobs' show?
> > >> --
> > >> Jim Smith
> > >> Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
> > >> RSS <http://oracleandting.blogspot.com/atom.xml>
> > >
> >
> > --
> > Jim Smith
> > Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
> > RSS <http://oracleandting.blogspot.com/atom.xml>

That's how you repay! I was the first to question for the JOB_QUEUE_PROCESSES ;))
(Just kidding.)

JOB_QUEUE_PROCESSES=10 will affect, but for better: Now you can have materialised views too!

Cheers.

Carlos Received on Fri Nov 24 2006 - 01:40:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US