oracle create chain rule

Solutions on MaxInterview for oracle create chain rule by the best coders in the world

showing results for - "oracle create chain rule"
Annabelle
18 Jan 2020
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;
Salvatore
19 May 2020
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;