issue in running multiple job in parallel
727104Oct 9 2009 — edited Nov 20 2009Hi,
I want to run six steps in parallel. I schedule it using following code.
DBMS_SCHEDULER.define_chain_rule (chain_name => 'pscrm_chain',
condition => 'TRUE',
action => 'START my_step1,my_step3,my_step5,my_step6,my_step9,my_step10',
rule_name => 'my_rule1',
comments => 'start the chain'
);
Chain is running fine but first it is starting my_step1,my_step3,my_step5,my_step6 jobs in parallel and then it will start my_step9,my_step10 jobs. I am not able to find where the issue is.
I checked in dba_scheduler_chain_rules table. I got following output which shows it should run all six jobs in parallel.
OWNER CHAIN_NAME RULE_OWNER RULE_NAME CONDITION ACTION COMMENTS
RTM13 PSCRM_CHAIN RTM13 MY_RULE1 TRUE START "MY_STEP1","MY_STEP3","MY_STEP5","MY_STEP6","MY_STEP9","MY_STEP10" start the chain
RTM13 PSCRM_CHAIN RTM13 MY_RULE2 my_step1 COMPLETED START "MY_STEP2" start the chain
RTM13 PSCRM_CHAIN RTM13 MY_RULE3 my_step3 COMPLETED START "MY_STEP4" start the chain
RTM13 PSCRM_CHAIN RTM13 MY_RULE4 my_step6 COMPLETED START "MY_STEP7" start the chain
RTM13 PSCRM_CHAIN RTM13 MY_RULE5 my_step6 COMPLETED AND my_step7 COMPLETED START "MY_STEP8" start the chain
RTM13 PSCRM_CHAIN RTM13 MY_RULE6 "my_step1 COMPLETED AND my_step2 COMPLETED AND my_step3 COMPLETED
AND my_step4 COMPLETED AND my_step5 COMPLETED AND my_step6 COMPLETED
AND my_step7 COMPLETED AND my_step8 COMPLETED AND my_step9 COMPLETED
AND my_step10 COMPLETED" START "MY_STEP11" start the chain
RTM13 PSCRM_CHAIN RTM13 MY_RULE7 my_step11 COMPLETED END
Please help me in locating the issue and how to resolve it.