dbms_job not running. HELP!

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 Received on Wed Nov 07 2001 - 10:15:25 CST