RE: dbms_scheduler schedule dependencies

From: Stephens, Chris <Chris.Stephens_at_adm.com>
Date: Tue, 2 Feb 2010 12:37:04 -0600
Message-ID: <D95BD5AFADBB0F4E9BB6C53F14D3A050049CE05BDD_at_JRCEXC1V1.research.na.admworld.com>

Currently we are on 10.2.0.4 but will be on 11.2 in the very near future.

From: Stephens, Chris
Sent: Tuesday, February 02, 2010 12:35 PM To: oracle-l_at_freelists.org
Subject: dbms_scheduler schedule dependencies

Is there any way to determine what schedules are dependent on other schedulers?

So:

1. Create a named schedule that runs every day: begin dbms_scheduler.create_schedule( schedule_name => 'EAO_SCH_1', start_date => TO_DATE('2010-02-01 09:00', 'yyyy-mm-dd HH24:MI'), repeat_interval => 'FREQ=DAILY;'); end;
2. Create a named schedule that runs on the 15th of each month: begin dbms_scheduler.create_schedule( schedule_name => 'EAO_SCH_2', start_date => TO_DATE('2010-02-01 09:00', 'yyyy-mm-dd HH24:MI'), repeat_interval => 'FREQ=MONTHLY;BYMONTHDAY=15;'); end;
3. Create a combined schedule, #1 excluding #2: begin dbms_scheduler.create_schedule( schedule_name => 'EAO_SCH_3', start_date => TO_DATE('2010-02-01 09:00', 'yyyy-mm-dd HH24:MI'), repeat_interval => 'EAO_SCH_1;EXCLUDE=EAO_SCH_2;'); end;

A way to figure out that eao_sch_3 Is dependent on eao_sch_2 & 1?

CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 02 2010 - 12:37:04 CST