Re: Job schedule

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 3 Feb 2005 22:45:41 +0000
Message-ID: <bf4638050203144568924ff4@mail.gmail.com>

On Thu, 3 Feb 2005 08:19:06 -0800, Terry Sutton <terrysutton_at_usa.net> wrote:
> If you're using the dbms_job queue, your interval would be something like
> 'trunc(decode(to_char(sysdate,''DAY''), ''SATURDAY '', sysdate + 3,
> ''SUNDAY '', sysdate + 2, sysdate + 1)) + 5/24'

Don't forget to include a time component in the spec.

As stated the start time for this job will creep by the runtime of the job.

Include a time component to avoid that.

eg. trunc(sysdate) + 3 + (5/24 )

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 03 2005 - 17:48:29 CST