hello i just learn this concept named "job chain" i have a little bit confusion about the job chain step.
for example
exec DBMS_SCHEDULER.CREATE_CHAIN(chain_name => 'chain1');
i create a chain called chain1 and then add 3 step to it
exec DBMS_SCHEDULER.DEFINE_CHAIN_STEP(chain_name => 'chain1', step_name => 'step1', program_name => 'program1');
exec DBMS_SCHEDULER.DEFINE_CHAIN_STEP(chain_name => 'chain1', step_name => 'step2', program_name => 'program2');
exec DBMS_SCHEDULER.DEFINE_CHAIN_STEP(chain_name => 'chain1', step_name => 'step3', program_name => 'program3');
and then make a job for that chain
DBMS_SCHEDULER.CREATE_JOB (job_name => 'chainjob1',job_type => 'CHAIN',job_action => 'chain1',repeat_interval =>'freq=daily;byhour=12;byminute=0;bysecond=0',enabled => TRUE);
and the run the job
exec DBMS_SCHEDULER.RUN_CHAIN(chain_name=>'chain1',start_steps=>'step1');
and
exec DBMS_SCHEDULER.RUN_CHAIN(chain_name=>'chain1',start_steps=>'step1,step2');
my question is :
1.when we run the job from start_steps=>'step1' does it run from step1 then step 2 then step3 in sequence?
2.when we run the job using start_steps=>'step1,step2' does the job chain run simultaneously(both 1 and 2 run first )? if so when does step 3 will run? when both finished or just one of the step is finished?
thanks