Re: DBMS_JOBS

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>
Received on Thu Nov 23 2006 - 09:03:07 CST