To create and run a scheduled job chain, you must use the following steps:

1. Create the Chain
2. Define the Chain Steps
3. Add Rules
4. Create Scheduled Programs
5. Enable the Chain
6. Create a Job Schedule

1. Create the Chain

The following procedure DBMS_SCHEDULE.CREATE_CHAIN is used to create the chain. The chain name – REFRESH_TEST.REFRSH_PROC is in the format of schema name.chain name;l see Listing 5.

BEGIN
  SYS.DBMS_SCHEDULER.CREATE_CHAIN (
     chain_name          => 'REFRESH_TEST.REFRESH_PROC'
    ,rule_set_name       => NULL
    ,evaluation_interval => NULL
    ,comments            => 'Refresh test database');
END;