Friday, August 20, 2010

DBMS_JOB interval examples

The job will run every hour at HH:30. For example, if SYSDATE is 14:38 then the job will run at 15:30.

trunc(sysdate + 1/24 , 'HH' ) + 30/60/24

++++++++++++++++++++++
at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)