1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Batch Processing
  3. Scheduling Jobs

Scheduling Jobs

The scheduling jobs feature provides a method to orchestrate the execution times of data load rules.

Note:

When you cancel a job from the Data Management user interface using Cancel Schedule, all instances of a schedule for a rule are cancelled. You cannot selectively cancel individual schedules for a rule.


Image shows Schedule screen.

To schedule a job:

  1. From the Batch Execution screen or Data Load Rule screen, select the batch name (from the Batch Execution or Data Load screen) and click Schedule.
  2. In Schedule, select any rule feature specific options.

    For example, if you select the Schedule option from the Data Load Rule screen, specify the Import from Source, Recalculate, Export to Target, and so on options.

  3. Specify the type of scheduling and select the associated date and time parameters.

    See Table 4-1.

  4. Click OK.

Table 4-1 Schedule Types and Parameters

Schedule Type Data and Time Parameters
Simple

Submits the job for execution at a specific day and time, but does not repeat:

Available options:

  • Timezone

  • Date

  • Hour(s)

  • Minute(s)

  • Second(s)

  • Select (AM/PM)
Hourly

Executes at the specified minutes and seconds after the top of the hour every hour until cancelled.

Available options:

  • Timezone

  • Minute(s)

  • Second(s)
Daily

Executes at the same time each day.

Available options:

  • Timezone

  • Hour(s)

  • Minute(s)

  • Second(s)

  • Select (AM/PM)
Weekly

Executes at the specific time for each day selected.

Available options:

  • Timezone

  • Monday-Sunday

  • Hour(s)

  • Minute(s)

  • Second(s)

  • Select (AM/PM)
Monthly (day of month)

Execute at the specific time for the day of the month selected. Also enables you to select the "Last Day of Month" or "Day Before End of Month".

Available options:

  • Timezone

  • Monthly Date

  • Hour(s)

  • Minute(s)

  • Second(s)

  • Select (AM/PM)
Monthly (week day)

You can select the first, second, third, fourth, fifth, last, and then the specific day or the week on which to execute the job.

Available options:

  • Day of Month

  • Day

  • Hour(s)

  • Minute(s)

  • Second(s)

  • Select (AM/PM)

Note:

The Timezone option is unavailable for the Monthly (week day) schedule type.