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: oracle-world.com

Similar codes

44 votes229 views6 answers
Rename command in sql
SQL
4 votes144 views1 answer
SQL order random
SQL
4 votes163 views3 answers
Drop Table Oracle
SQL
12 votes153 views1 answer
How to change the value of a table in sql
SQL
0 vote192 views1 answer
Sql to excel pgadmin
SQL
4 votes196 views2 answers
Convert utc to est sql
SQL
1 vote156 views2 answers
Test sqlsrv connection
SQL
0 vote154 views1 answer
Sql shell psql cannot enter password
SQL
0 vote176 views1 answer
Sql insert query list of dictionaries
SQL
0 vote152 views1 answer
Insert array into mysql column
SQL