Re[2]: dbms_job - running jobs every 15 minutes

Vladimir,

    I beg to disagree. The reason is that we used a number of jobs where the interval was defined as "sysdate+1" and the job routinely ran for ~30 minutes every day. The result was that the job migrated over the course of a week by 3.5 hours so that instead of running at 6AM as scheduled on Monday it was running at 9:30 AM on the next Monday. I filed an iTar on the subject which resulted in OTS providing what I stated. Interval is evaluated at the end of the job, not the start.

Dick Goulet

____________________Reply Separator____________________
Author: Vladimir Begun <vladimir.begun_at_oracle.com>
Date:       1/22/2003 9:40 AM

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: dgoulet_at_vicr.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).