dbms_scheduler schedule dependencies

  • From: "Stephens, Chris" <Chris.Stephens@xxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 2 Feb 2010 12:35:23 -0600

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.


Other related posts: