dbms_job not Working

I have a job named checkwaits that I schedule to run every two minutes
using dbms_jobs.  This worked smoothly until early January when we
applied the October CPU.  After this, it stopped working, but I didn't
know it stopped working until just today.  I removed the job and
resubmitted it, but it is still not running the job according to the
schedule.  If I manually run the job using "exec dbms_job.run(62);" it
does execute.  

 

Here is the script I used to re-submit the job (logged on as user
dbatools):  

-- Submit to run every 2 minutes:

variable jobno number;

begin

  dbms_job.submit(:jobno,'dbatools.checkwaits;',sysdate+1/1440,'sysdate
+ 2/1440');

  commit;

end;

/

 

Then I query dba_jobs while logged on as system:

system@PROD> l

  1  select job, log_user, priv_user, last_date, last_sec, next_date,
next_sec, broken,

  2  interval, failures, what

  3  from dba_jobs

  4* where job=62

system@PROD> /

 

LOG_USER   PRIV_USER                      LAST_DATE           LAST_SEC
NEXT_DATE           NEXT_SEC B INTERVAL               FAILURES

---------- ------------------------------ ------------------- --------
------------------- -------- 

WHAT

--------------------

DBATOOLS   DBATOOLS
2007-03-08 16:53:06 16:53:06 N sysdate + 2/1440

dbatools.checkwaits;

 

 

So even though the next_date is set to 1 minute in the future when the
job is submitted, it is not run (not even 20 minutes afterwards).

 

Can anybody point me in the right direction on how I can get this
working again.

 

Thanks,

 

Sam Bootsma

Oracle Database Administrator

Information Technology Services
George Brown College

Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma@xxxxxxxxxxxxxx <mailto:sbootsma@xxxxxxxxxxxxxx>

Other related posts: