Forum Stats

  • 3,826,859 Users
  • 2,260,714 Discussions
  • 7,897,105 Comments

Discussions

DBMS SCHEDULER : Nested Chains

697372
697372 Member Posts: 13
edited Jun 16, 2009 3:37AM in Scheduler
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.

Answers

  • Ronald Rood
    Ronald Rood Member Posts: 323 Bronze Badge
    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.