1BEGIN
2 DBMS_SCHEDULER.DEFINE_CHAIN_RULE(
3 CHAIN_NAME => 'chain1',
4 CONDITION => 'TRUE', -- starting step
5 ACTION => 'START step1',
6 RULE_NAME => 'chain1_rule1',
7 COMMENTS => 'Starting chain');
8END;
1SELECT OWNER,
2 CHAIN_NAME,
3 RULE_OWNER,
4 RULE_NAME,
5 CONDITION,
6 ACTION,
7 COMMENTS
8FROM DBA_SCHEDULER_CHAIN_RULES
9ORDER BY OWNER, CHAIN_NAME, RULE_OWNER, RULE_NAME;