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 creating custom schedule

xxsawerJun 12 2019 — edited Jun 12 2019

Hi All,

I have database job and I would need to trigger it on specified days at specified time(s) per day. For example I would like to trigger it each:

Monday 7:00

Tuesday 5:00

Wednesday 6:00, 15:00

Sunday 11:00

Is there a way how to achieve this via DBMS_SCHEDULER.CREATE_SCHEDULE? I am a bit lost in all those options calendaring syntax is providing...

Thanks for all suggestions.

Dan

This post has been answered by Solomon Yakobson on Jun 12 2019

Jump to Answer

Added on Jun 12 2019

7 comments

732 views