Database Software

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!

Oracle Scheduler: create different schedule time per day

user2908155Apr 20 2015 — edited Apr 20 2015

Hi,

Is it possible to create different schedule times based on the day?

Example I've schedule a backup-job to run every day @ 23h

So i configured my job as :

execute dbms_scheduler.set_attribute(name=>'DAILY_BACKUP_JOB',attribute=>'repeat_interval',value=>'FREQ=DAILY;BYHOUR=23;BYMINUTE=00');

But now I want to fine tune this and I like to start the job every sunday @ 21h.

is this possible to configure this is the same job? Or do I have to create 2 separate jobs for it? One for MON - SAT @ 23h and another for SUN @ 21h?

Kind regards,

This post has been answered by GregV on Apr 20 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 18 2015

Added on Apr 20 2015

#database-key-features, #scheduler

2 comments

2,583 views