Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: JOB interval 1 minute but last_date - next_date < 1 min
Vladimir M. Zakharychev wrote:
> This is because SNPs are not guaranteed to start the job exactly at next_date,
> just *some time past* the next_date. This is why rounding is usually required
> in next_date formula, otherwise these errors will accumulate.
>
No sure about the above, but it's a fact that the rescheduling is
done *after* completion. A post of the next statement (start with ...
next ...) would be helpful.
If your job runs for a minute, and next would be 1 minute, too, the
reschedule would take place at 15:01 for... 15:02.
Make perfect sense.
-- Regards, Frank van BortelReceived on Sat Apr 26 2003 - 10:08:25 CDT
![]() |
![]() |