how do I create a schedule
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