1BEGIN
2DBMS_SCHEDULER.DEFINE_CHAIN_STEP (
3 chain_name => 'my_chain1',
4 step_name => 'my_step1',
5 program_name => 'my_program1');
6DBMS_SCHEDULER.DEFINE_CHAIN_STEP (
7 chain_name => 'my_chain1',
8 step_name => 'my_step2',
9 program_name => 'my_chain2');
10END;
1BEGIN
2DBMS_SCHEDULER.CREATE_CHAIN (
3 chain_name => 'my_chain1',
4 rule_set_name => NULL,
5 evaluation_interval => NULL,
6 comments => 'My first chain');
7END;