CODE EXAMPLE FOR SQL

oracle chain step succeeded

 DBMS_SCHEDULER.DEFINE_CHAIN_RULE(
      CHAIN_NAME => 'CHAIN1',
      CONDITION => 'STEP1 SUCCEEDED', -- starting step 2
      ACTION => 'START STEP2',
      RULE_NAME => 'RULE2',
      COMMENTS => 'Starting step 2');