Skip to Main Content

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!

Scheduling job every half hour

Kevin TysonSep 22 2005 — edited Sep 26 2005
I want to schedule a job every half hour on the half or the hour. Using interval=>'sysdate + 1/48' does not work because each successive job is scheduled in a half hour plus a few seconds. Over time the schedule increasingly deviates from the half.

I scheduled a job successfully every hour on the hour with 'trunc(sysdate, ''HH24'') + 1/24'. Now how do I schedule a job every half hour on the hour or the half?

Thanks for your help.

Kevin Tyson, OCP
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2005
Added on Sep 22 2005
6 comments
2,224 views