Re: Job schedule
- From: "Terry Sutton" <terrysutton@xxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 4 Feb 2005 17:20:10 -0800
The trunc in 'trunc(decode...) + 5/24' doesn't do this?
--Terry
(noting that Connor's suggestion is a bit easier to read in a job queue)
----- Original Message -----
From: "Jared Still" <jkstill@xxxxxxxxx>
To: <terrysutton@xxxxxxx>
Cc: <Oracle-L@xxxxxxxxxxxxx>
Sent: Thursday, February 03, 2005 2:45 PM
Subject: Re: Job schedule
On Thu, 3 Feb 2005 08:19:06 -0800, Terry Sutton <terrysutton@xxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
