Scheduling Jobs

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

Note:

When you cancel a job from the Oracle Hyperion Financial Data Quality Management, Enterprise Edition user interface, all instances of a schedule for the object selected are cancelled. To cancel a specific instance of a schedule, cancel the job from the ODI studio or ODI console.


Image shows Schedule screen.

To schedule a job:

  1. From the Batch Execution screen, Metadata screen, or Data Load Rule screen, select the batch name (from the Batch Execution screen) or rule (from the Metadata screen or Data Load Rule screens) to schedule 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 6-1.

  4. Click OK.

Table 6-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.