Re: Jobs will not run

Hi,

What is the value for Job_Queue_Process and Job_Queue_Internal in your system.

May be you have set it to zero. If the Job_Queue_processes is set to Zero your jobs wont execute.

HTH Regards,
Ganesh R

"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message news:<ufh8hpdh47r5f8_at_corp.supernews.com>...
> I have seen cases where once in a while you need to 'kick' start it by
> manaually running it once.
>
> exec dbms_job.run(job_no)
>
> Also make sure the init.ora parameter job_queue_processes is > 0
>
> and verify the value of parameter
> job_queue_interval
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
>
> Author of: 'So You Want to be an Oracle DBA?'
>
>
>
> "Ronald" <ronald_at_nowhere.com> wrote in message
> news:ada77g$v42tj$1_at_ID-87429.news.dfncis.de...
> >
> > What could be the possible cause of DBMS_JOB
> > job not being run?
> >
> > My job will not run, although it's submitted OK.
> > I can see it in USER_JOBS, but it's simply
> > not being triggered.
> >
> > (Now it's 28 hours since NEXT_DATE
> > in USER_JOBS for this job. Of course, LAST_DATE is
> > still NULL.)
> >
> > Command, as entered in SQL*Plus:
> >
> > VARIABLE jobno NUMBER;
> > BEGIN
> > DBMS_JOB.SUBMIT(:jobno, 'my_proc(sysdate);', SYSDATE+3/1440,
> > 'SYSDATE+12/1440');
> > COMMIT;
> > END;
> >
> >
> >
> > Is there some gotcha?
> >
> > Platform is 8.1.6 on Windows.
> >
> >
Received on Sat Jun 01 2002 - 14:29:20 CDT