Yup, Kevin, it was the job erroring that was causing it to resubmit itself every 24 hours. At least after 11 or so failures, it did. I threw in some error trapping, and all's well.
Thanks! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: kkennedy [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 1:44 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: DBMS_JOB interval wierdness > > > When the job aborts, it increments the failures column (until > it hits the broken point at 16 failures) and resubmits itself > with an internally calculated restart time. > > From the Oracle Administrators Guide: > If a job returns an error while Oracle is attempting to > execute it, Oracle tries to execute it again. The first > attempt is made after one minute, the second attempt after > two minutes, the third after four minutes, and so on, with > the interval doubling between each attempt. When the retry > interval exceeds the execution interval, Oracle continues to > retry the job at the normal execution interval. However, if > the job fails 16 times, Oracle automatically marks the job as > broken and no longer tries to execute it. > > Works that way here. I can't say why yours reruns every day > at 1PM. I can say that if you trap the error and get a > normal completion, your problem is solved. > > Kevin Kennedy > First Point Energy Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
