Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
DBMS SCHEDULER : Nested Chains
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.
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.
Answers
-
Hi,
you could try to do this in a chain, you can build loops in a chain but what do you expect that happens after Rule_5
Condition = 'PROGRAM_3 SUCCEEDED '
Action = END ?
What will happen is regardless of what chain2 is doing, it will be terminated when the END is executed. In this construction it is hard to create a real repeat interval but you could code a rule that after completion of chain2 starts chain2 again with a delay of five minutes.
I hope this helps,
Ronald
http://ronr.blogspot.com
This discussion has been closed.