Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: JOB interval 1 minute but last_date - next_date < 1 min

Re: JOB interval 1 minute but last_date - next_date < 1 min

From: Frank <fvanbortel_at_netscape.net>
Date: Sat, 26 Apr 2003 17:08:25 +0200
Message-ID: <3EAAA0E9.5080300@netscape.net>


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 Bortel
Received on Sat Apr 26 2003 - 10:08:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US