Re: dbms_job not running. HELP!

"Andrew Johnson" <andrew.johnson_at_int-link.com> wrote in message news:2d497485.0111070815.6129ab56_at_posting.google.com...
> Hi,
>
> I am trying to create a series of scheduled jobs (running procedures
> at set intervals) using Oracle 9i running on Win2000.
>
> I have been trying to use dbms_job but I'm having difficulties. The
> following is the code I am trying (which returns no errors):
>
> DECLARE
> jobno BINARY_INTEGER;
> BEGIN
> DBMS_JOB.SUBMIT(jobno, 'iss_tester_proc;', SYSDATE, 'SYSDATE+1/48',
> TRUE);
> END;
>
> The proc is only a simple example and works when executed from the
> command line. It also works if I force it to run by running:
>
> exec dbms_job.run(17);
>
> After forcing it in this way, the last and next executed columns in
> the user_jobs table are updated.
> (as shown)
>
> select job, next_date, next_sec, failures, broken,last_date, last_sec
> from user_jobs;
>
> JOB NEXT_DATE NEXT_SEC FAILURES B LAST_DATE LAST_SEC
> ------ --------- -------- ---------- - --------- --------
> 17 07-NOV-01 15:42:43 0 N 07-NOV-01 15:35:13
>
> However, when the next time (NEXT_SEC) arrives nothing happens.
>
> I have checked in Oracle Enterprise Manager and the database is not
> running in restricted mode and the proc does contain a commit.
>
> Any help would be greatly received..
>
> Cheers,
>

You didn't commit the call to dbms_job.submit, did you. Anyway that's not in your code.
Also could you please verify whether job_queue_process is non-zero and job_queue_interval ditto?

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address



> Andrew D Johnson