Database Administration (MOSC)

MOSC Banner

how do I create a schedule

edited Mar 14, 2023 9:30PM in Database Administration (MOSC) 9 commentsAnswered ✓

We have a requirement to create a job schedule like so:

'FREQ=daily; byday=Mon,Tue, Wed, Thu, Fri; byhour=6,8,10,12,14,16,22; BYMINUTE=0;BYSECOND=0'

and

'FREQ=daily; byday=Sun; byhour=10; BYMINUTE=0;BYSECOND=0'

the reason it must be one job schedule is because the jobs cannot overlap due to locking issues

How do I specify this in the repeat_interval of DBMS_SCHEDULER.CREATE_SCHEDULE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center