62. 3 program_name => 'hr.program3',

63. 4 program_type => 'PLSQL_BLOCK',

64. 5 program_action => 'BEGIN

65. 6 INSERT INTO hr.chain1 (id, description, created_date)

66. 7 VALUES (seq_chain.NEXTVAL, ''program3'', SYSDATE);

67. 8 COMMIT;

68. 9 END;',

69. 10 enabled => TRUE,

70. 11 comments => null);

71. 12* END;

72. PL/SQL procedure successfully completed.

创建作业链

定义链规则

1. SQL> BEGIN

2. 2 DBMS_SCHEDULER.define_chain_rule (

3. 3 chain_name => 'chain_1',

4. 4 condition => 'TRUE',

5. 5 action => 'START step1',

6. 6 rule_name => 'chain_rule_1',

7. 7 comments => 'First link in the chain.');

8. 8 DBMS_SCHEDULER.define_chain_rule (

9. 9 chain_name => 'chain_1',

10. 10 condition => 'step1 completed',

11. 11 action => 'START step2',

12. 12 rule_name => 'chain_rule_2',

13. 13 comments => 'Second link in the chain.');

14. 14 DBMS_SCHEDULER.define_chain_rule (

15. 15 chain_name => 'chain_1',

16. 16 condition => 'step2 completed',

17. 17 action => 'START step3',

18. 18 rule_name => 'chain_rule_3',

19. 19 comments => 'Third link in the chain.');

20. 20 DBMS_SCHEDULER.define_chain_rule (

21. 21 chain_name => 'chain_1',

22. 22 condition => 'step3 completed',

23. 23 action => 'END',

24. 24 rule_name => 'chain_rule_4',

25. 25 comments => 'End of the chain.');

26. 26* END;

27. PL/SQL procedure successfully completed

启用链

1. SQL> BEGIN

2. 2 DBMS_SCHEDULER.enable ('chain_1');

3. 3* END;

4. PL/SQL procedure successfully completed

测试：

1. SQL> BEGIN

2. 2 DBMS_SCHEDULER.run_chain (

3. 3 chain_name => 'chain_1',

4. 4 job_name => 'chain_1_run_job',

5. 5 start_steps => 'step1, step2, step3,step4');

6. 6* END;

7. PL/SQL procedure successfully completed.

8.

9. SQL> select * from chain1 order by 1;

10.

11. ID DESCRIPTIO CREATED_DATE

12. ---------- ---------- -------------------

13. 3 program1 2011-08-09-14:27:57

14. 4 program2 2011-08-09-14:27:57

15. 5 program3 2011-08-09-14:27:57

四:作业链相关的动态性能视图

[DBA | ALL | USER]_SCHEDULER_CHAINS

[DBA | ALL | USER]_SCHEDULER_CHAIN_RULES

[DBA | ALL | USER]_SCHEDULER_CHAIN_STEPS

本文出自 “月牙天冲” 博客