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>