5. Enable the Chain
This final chain step will send me an email when all of the previous steps are completed successfully. Now that my chain, chain rules and chain programs have been created, it is now time to enable my chain. Listing 10 shows a procedure that enables a chain.
BEGIN SYS.DBMS_SCHEDULER.ENABLE (name => 'REFRESH_TEST.REFRESH_PROC'); END;