Re: DBMS_JOBS

Sorry Carlos

At that time i didn't know anything about "job_queue_processes." Now i know because of you guys!!!!!!!!!!! Thanks anyway.

Thanks,
Gowree

Carlos wrote:
> 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 - 19:43:04 CST