OraFAQ Forum: Enterprise Manager » Oracle Join Schedules together

Home » RDBMS Server » Enterprise Manager » Oracle Join Schedules together

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Join Schedules together [message #254690]

Fri, 27 July 2007 09:09

yamon
Messages: 22
Registered: July 2006

Junior Member

Hi,

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.

Yamon

Report message to a moderator

Re: Oracle Join Schedules together [message #254694 is a reply to message #254690]

Fri, 27 July 2007 09:53

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

some thing like this

begin
    dbms_scheduler.create_schedule
    (
       schedule_name   => 'EVERY_30_MINS',
       repeat_interval => 'FREQ=MINUTELY; INTERVAL=30',
       comments        => 'Every 30-mins'
    );
end;
/

for more information visit
http://www.oracle.com/technology/pub/articles/10gdba/week19_10gdba.html

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 23:18:29 CDT 2024