Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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):
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_at_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_at_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_at_georgebrown.ca <mailto:sbootsma_at_georgebrown.ca>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 08 2007 - 16:17:50 CST
![]() |
![]() |