Re: dbms_job - running jobs every 15 minutes

dgoulet_at_vicr.com wrote:
> One potential problem with DBMS_JOBS as is being discussed here is that Oracle
> computes the next_date at the end of the job. They do that so that if a job

• INTERVAL is a date function, evaluated immediately before the job starts
• executing...

> runs longer than it's schedule interval the two invocations will not run into
> each other. Now as discussed, if the job is scheduled to start at 9:00 AM and
> runbs for 5 minutes it's next_date for run #2 will be 9:20, not 9:15, and it
> will creep 5 minutes every time.

Regards,

-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vladimir Begun
  INET: vladimir.begun_at_oracle.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).