Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS SCHEDULER : Nested Chains

697372Jun 16 2009 — edited Jun 16 2009

Hi,

I am working on Oracle 10.2 version. I have a requirement where a chain step should point to the another chain and this second chain should have the repeat interval of every 5 mins.

Ideally I would like to have the chain as following.

Rule_1
Condition = 'TRUE'
Action= START PROGRAM_1

Rule_2
Condition ='PROGRAM_1 SUCCEEDED'
Action = START PROGRAM_2

Rule_3
Condition = 'PROGRAM_2 SUCCEEDED'
Action = START CHAIN_2

Rule_4
Condition = 'PROGRAM_2 SUCCEEDED '
Action = START PROGRAM_3

Rule_5
Condition = 'PROGRAM_3 SUCCEEDED '
Action = END

Basically, after the successful completion of program_2, chain_2 should start and from then chain_2 has to restart for every 5 mins.

Is this possible?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2009

Added on Jun 16 2009

#database-key-features, #scheduler

1 comment

2,857 views