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

0 vote233 views1 answer
How to check xampp mysql password
SQL
0 vote233 views1 answer
Mysql get date diff in months
SQL
0 vote227 views1 answer
Openquery insert into linked server
SQL
8 votes237 views1 answer
Sql remove leading spaces
SQL
4 votes227 views3 answers
Drop Table Oracle
SQL
16 votes208 views3 answers
Order by sql query
SQL
3 votes210 views1 answer
Difference sql vs mysql
SQL
0 vote234 views3 answers
Sql server import json
SQL
-1 vote188 views2 answers
Datetime sql server week
SQL
0 vote236 views1 answer
Connect to nginx server mysql remotly
SQL