Dear all,
how to run chain flowing my defined step?
Begin
dbms_Scheduler.Create_Chain(Chain_Name => 'MYTEST_CHAIN');
dbms_Scheduler.Define_Chain_Step(chain_name =>'MYTEST_CHAIN',
step_name =>'mytest_chain_1',
program_name =>'p_step1');
dbms_Scheduler.Alter_Chain(chain_name => 'MYTEST_CHAIN',
step_name => 'mytest_chain_1',
attribute => 'skip',
value => False
);
dbms_Scheduler.Define_Chain_Step(chain_name =>'MYTEST_CHAIN',
step_name =>'mytest_chain_2',
program_name =>'p_step2');
dbms_Scheduler.Alter_Chain(chain_name => 'MYTEST_CHAIN',
step_name => 'mytest_chain_2',
attribute => 'skip',
value => False
);
dbms_Scheduler.Enable('MYTEST_CHAIN');
End;
I have create chain name 'MYTEST_CHAIN' and contain two steps named 'mytest_chain_1' and 'mytest_chain_2'.
I want to run the chain just as flowing,but it cann't not work,why?
Begin
Dbms_Scheduler.Run_Chain(Chain_Name => 'MYTEST_CHAIN',
start_steps => Null,
Job_Name => Null);
End;