SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

change repeat_interval in job

user1980Mar 6 2009 — edited Mar 9 2009

I need to change the job interval to run once after midnight.

Currently the interval is :

start_date       => systimestamp,
repeat_interval => 'FREQ=MINUTELY; INTERVAL=5'

I plan to change it to

start_date       => systimestamp,
repeat_interval => 'FREQ=DAILY; INTERVAL=( TRUNC(sysdate) + 1 ) +( 2 /24/60 ) '

Job should run 2 minutes past midnight..

Is this correct?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2009

Added on Mar 6 2009

5 comments

8,424 views