FreeLists / oracle-l / Re: oracle

[Paula Stankus <paulastankus@xxxxxxxxx>]

  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;
  /
   

                
---------------------------------
Do you Yahoo!?
 Next-gen email? Have it all with the  all-new Yahoo! Mail Beta.