DBMS_JOB INTERVAL PARAMETER TIP

Hello

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')

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 CDT