Home » RDBMS Server » Enterprise Manager » Oracle Join Schedules together
Oracle Join Schedules together [message #254690] Fri, 27 July 2007 09:09 Go to next message
Messages: 22
Registered: July 2006
Junior Member

Using Oracle 10g R2, dbms_scheduler.create_schedule allows an INCLUDE attribute to include other days into a schedule. However, it does not cover other times. Does anyone know how to create a schedule for MON-SAT 9am-5pm *AND* SUN 5pm - In one schedule? Or do I have to create two different jobs, one for MON-SAT 9am-5pm, and one for SUN 5pm? As I said, my understanding is that INCLUDE only includes other days, not times.

Many thanks for any advice.

Re: Oracle Join Schedules together [message #254694 is a reply to message #254690] Fri, 27 July 2007 09:53 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
some thing like this

       schedule_name   => 'EVERY_30_MINS',
       repeat_interval => 'FREQ=MINUTELY; INTERVAL=30',
       comments        => 'Every 30-mins'

for more information visit
Previous Topic: SYS account instead of DBSNMP in GC
Next Topic: ORA-28547: connection to server failed, probable Oracle net admin error
Goto Forum:

Current Time: Sun Oct 23 04:56:50 CDT 2016

Total time taken to generate the page: 0.08581 seconds