| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: oracle
Oracle 8.1.7, Solaris 2.9. We have a job that is not running properly. Could that be why it is unexpectedly trying to execute at a different time when the next scheduled execution time should have been August 5
2006. Also the next run date is now showing as August 2 at 4 AM. We are
trying to understand why it should have done so even though everything
else is the same in the job properties. The properties show the interval
as
TO_DATE('5-'|| TO_CHAR(ADD_MONTHS(sysdate,1),'MON-YYYY'), 'DD-MON-YYYY')
+ 00.50/24
We recently executed the following to change the package - the package fails at the same time each day - the time of deployment - not the scheduled time. Also, around this same time the status of the job was switched from broken (for deployment) to fixed:
BEGIN
DBMS_JOB.WHAT(342,
'cpsdataminer_pkg_p3.cpseompenaltycalc;');
END;
/
 |
 |