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: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Fri, 25 Apr 2003 16:25:16 +0400
Message-ID: <b8b9gt$oka$1@babylon.agtel.net>


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...

> 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...
>
>
Received on Fri Apr 25 2003 - 07:25:16 CDT

Original text of this message

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