Andrew Johnson wrote:
>
> 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,
>
> Andrew D Johnson
Did you set the init params to start the job processes?
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Wed Nov 07 2001 - 11:29:41 CST
