Re: DBMS_JOB INTERVAL PARAMETER TIP

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 CEST