Re: DBMS_JOB INTERVAL PARAMETER TIP

From: Brett Neumeier <random_at_enteract.com>
Date: 1998/07/16
Message-ID: <6olnb8$3uu$1@eve.enteract.com>#1/1

In comp.databases.oracle.misc Matthew MacFarland <matthew_mac&*(^%farland_at_dril-quip.com> wrote:
> To set the INTERVAL parameter of a DBMS_JOB job to run at a specific time of
> day use the following expression:
> to_date(trunc(sysdate + 1,'DDD')||' 16:00:00','DD-MON-YY HH24:MI:SS')

Alternatively,

'trunc(sysdate) + 40/24'

Will do the same thing. (the trunc(sysdate) gives you midnight of the current day; adding 1 gives midnight tomorrow; adding 16/24 adds 16 hours, bringing you to 4pm.)

-bn
random_at_enteract.com Received on Thu Jul 16 1998 - 00:00:00 CDT