Re: What to look for when a scheduled Job doesn't run?

Oh yes. A related error what me no it couldn't have been guv, is to assume that the interval parameter is in seconds.

so

dbms_job.submit(
interval => sysdate + 900)

which was supposed to repeat every 15 minutes didn't work entirely as planned....

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Legal disclaimer required by my employer
****************************************************************************
**
This email contains information intended for the addressee only.
 It may be confidential and may be the subject of legal and/or professional
privilege.
Any dissemination, distribution, copyright or use of this communication
without prior permission of the addressee is strictly prohibited.
****************************************************************************
**

"Alistair Thomson" <thomson_alistair_at_yahoo.co.uk> wrote in message
news:9kbv15$p69$1_at_newsreaderg1.core.theplanet.net...


> You might also check the server date and time. I once waited for a job to

> run  only to find the server date was set 2 years ahead! Thats a long wait

> for a job to run!!!

>

> Alistair

>

> Lee Staples <lee_at_cybicom.co.za> wrote in message

> news:996573861.848787_at_proxy.storm.co.za...

> > I have managed to successfully submit a job to my 8.04 database, which

 runs


> > quite happily every day at the required time.  My problem is that I

 cannot


> > get the job to run on the production database (8.05).  Are there any

> > parameters or anything that I should check?  I have set

> > "job_queue_processes=1" (mine is the only job runnning on the database).

> >

> > Thanks.

> > Lee.

> >

> >

>

>