Re: Execution interval is incorrect while using DBMS_JOB.SUBMIT

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 19 Aug 2004 06:28:31 -0700
Message-ID: <1092922159.408784@yasure>

Eric Parker wrote:

> "Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message
> news:cg24p2$l3m$1_at_news2.tilbu1.nb.home.nl...
> <snip>
>

>>What Jim and Eric said.
>>And the reason is that Oracle reschedules the job _after_
>>it's completed, so if your schedule is "5 minutes later", your
>>job will rerun 5 minutes after *completion* of the previous run.
>>--
>>
>>Regards,
>>Frank van Bortel
>>

>
>
> Frank
>
> Its my understanding that Oracle calculates the interval prior to executing
> the job. If the job completes successfully then that value is used to
> schedule
> the next run otherwise it goes into its wait for an increasing period try
> again
> loop.
>
> eric

Not correct. Take a look at the dba_jobs view.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Aug 19 2004 - 08:28:31 CDT