Creating Execution Plans

To create an execution plan:

1. In the Oracle Data Relationship Management Analytics dashboard, select Settings.
2. Click Create and enter the following information:

   • Name––Enter a name for the execution plan

   • Schedule Type––Select from the following options:

     • Simple––Use to specify a start and end date

     • Cron––Use to specify a Cron expression

   • Scheduler Timeframe––Select Run Now or Future.

3. Click Next.
4. Do the following:

   • If you selected Simple as the Schedule Type and Run Now for the Scheduler Timeframe, do the following:

     1. Optional: Select Truncate and Load to truncate any tables associated with this job and reload based on the initial extract date in the system. If not selected, then an incremental load runs.

     2. Click OK if you are sure you want to truncate and load.

   • If you selected Simple as the Schedule Type and Future for the Scheduler Timeframe, do the following:

     1. Select the Frequency to run the execution plan: Daily, Weekly, or Monthly.

     2. Click to enter the start date and time.

     3. Optional: Click to enter the end date and time.

   • If you selected Cron as the Schedule Type, enter a Cron expression for when the scheduler will run.

5. Click Next.
6. Select jobs to add to the execution plan. User the Move, Move All, Remove, and Remove All buttons to move jobs from the Available list to the Selected list.
7. Click Next.
8. Review the execution plan settings and then click Schedule Plan.

   Note:

   For execution plans to run, the Scheduler must be started. To start the Scheduler, click and select Start.

9. Click OK to confirm scheduling plan.