oracle chain rules
SELECT OWNER, CHAIN_NAME, RULE_OWNER, RULE_NAME, CONDITION, ACTION, COMMENTS FROM DBA_SCHEDULER_CHAIN_RULES ORDER BY OWNER, CHAIN_NAME, RULE_OWNER, RULE_NAME;
Source: oracle-base.com
oracle create chain rule
BEGIN DBMS_SCHEDULER.DEFINE_CHAIN_RULE( CHAIN_NAME => 'chain1', CONDITION => 'TRUE', -- starting step ACTION => 'START step1', RULE_NAME => 'chain1_rule1', COMMENTS => 'Starting chain'); END;
Source: www.oracle-world.com