Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to run chain by defined steps

AndySkyJun 14 2011 — edited Jun 14 2011
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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2011
Added on Jun 14 2011
1 comment
158 views