Re: Execution interval is incorrect while using DBMS_JOB.SUBMIT

"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

--
Remove the dross to contact me directly