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!

dbms_scheduler every 3 hours

Angus123May 10 2021

hI

I am not sure if this is the correct forum for this question, but here we go.
I need to schedule a job
It should run every day of the week
Between the hours of 6am and 7pm
And only every 3 hours
Tried
freq=daily; byhour=7,8,9,10,11,12,13,14,15,16,17,18,19; byminute=00;interval=3
but it just schedules the job every hour

Any help appreciated
Regards
Gus

Comments
Post Details
Added on May 10 2021
3 comments
3,873 views