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 FDMEE 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.

    For Data Load Rule scheduling specific options, see Running Data Load Rules.

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

    See Table 43, Schedule Types and Parameters.

  4. Click OK.

Table 43. Schedule Types and Parameters

Schedule TypeData and Time Parameters
Simple

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

Options are:

  • Timezone

  • Date

  • Hour(s)

  • Minute(s)

  • Second(s)

  • Select (AM/PM)

HourlyExecutes at the specified minutes and seconds after the top of the hour every hour until cancelled. Options are:

  • Timezone

  • Minute(s)

  • Second(s)

DailyExecutes at the same time each day. Options are:

  • Timezone

  • Hour(s)

  • Minute(s)

  • Second(s)

  • Select (AM/PM)

WeeklyExecutes at the specific time for each day selected. Options are:

  • 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”. Options are:

  • 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. Options are:

  • 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.