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 vote326 views1 answer
Sql database connectivity
SQL
0 vote359 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
1 vote342 views3 answers
Execute sp in sql server
SQL
0 vote476 views1 answer
ORA-01400
SQL
0 vote332 views2 answers
Nested query
SQL
0 vote369 views1 answer
Psql check table fields
SQL
2 votes366 views3 answers
How to check current user in mySQL
SQL
0 vote403 views1 answer
Oracle calculate statistics on partition
SQL
1 vote373 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
1 vote349 views1 answer
Date in where on datetime column clause mysql
SQL