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
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.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Roman Grigoryan" <romich_at_dukascopy.com> wrote in message news:3ea8f659$1_1_at_news.bluewin.ch...Received on Fri Apr 25 2003 - 07:25:16 CDT
> JOB interval 1 minute but last_date - next_date < 1 min why?
>
> Job started in 15:00:00 then after 1 min have to be repeated, but the
> last_date wrote 15:00:02...
>
>
![]() |
![]() |