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 vote200 views1 answer
Sql server count all tables rows
SQL
0 vote193 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote183 views1 answer
Sql server select furst day of current year
SQL
0 vote194 views4 answers
How to connect form to database
SQL
8 votes188 views3 answers
Alter user root mysql
SQL
2 votes195 views2 answers
Set database timezone mysql
SQL
0 vote216 views1 answer
To Create directory
SQL
0 vote206 views1 answer
Psql show db
SQL
15 votes192 views2 answers
How to drop database name in postgresql
SQL
4 votes235 views2 answers
Insert current date in mysql
SQL