Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dbms_job not Working

dbms_job not Working

From: Sam Bootsma <sbootsma_at_georgebrown.ca>
Date: Thu, 8 Mar 2007 17:17:50 -0500
Message-ID: <CC7ECEDD58772D41A44D87EBED4A77A1022D6426@TCCEML02.gbrownc.on.ca>


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-l
Received on Thu Mar 08 2007 - 16:17:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US