DBMS_JOB INTERVAL PARAMETER TIP

Hello

[Quoted] 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')

[Quoted] [Quoted] This will run the job at 4:00 PM regardless of when the previous run completed.

Matthew MacFarland
Dril-Quip, Inc. Received on Thu Jul 16 1998 - 00:00:00 CEST