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

-----Original Message-----
Sent: Tuesday, July 16, 2002 11:26 AM
To: Multiple recipients of list ORACLE-L

Nope. 1 PM just like it should, only every day instead of every week. I've tried it with the "7" in and out of the TRUNC with the same results.

One other thing I just noticed is that the job returns an error each time it is run due to bug in DBMS_STATS. I'm rectifying that now with trapping and an error table, but I'm still confused as to why it would resub in a day instead of the interval.

Thx!

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
> Sent: Tuesday, July 16, 2002 11:31 AM
> To: Jesse, Rich; Multiple recipients of list ORACLE-L
> Subject: Re:DBMS_JOB interval wierdness
>
>
> Jesse,
>
> No joke, let me guess, 8am every day, right? Try
> TRUNC(SYSDATE+7)+1/24
> instead.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Subject: DBMS_JOB interval wierdness
> Author: "Jesse; Rich" <Rich.Jesse_at_qtiworld.com>
> Date: 7/16/2002 9:08 AM
>
> Hey all,
>
> I've got a job to gather stats on a schema of an 8.1.6.0.0
> DB. The interval
> of the DBMS_JOB is:
>
> TRUNC(SYSDATE)+7+1/24
>
> ...but it keeps resubmitting itself every day, instead of once a week.
>
> I *must* be brain dead or this cold's getting the best of me,
> because I just
> can't see what I'm missing.
>
> Anyone? Bueller? Bueller?
>
> Rich Jesse

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

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: ListGuru_at_fatcity.com (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: kkennedy
  INET: kkennedy_at_firstpoint.com

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: ListGuru_at_fatcity.com (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).