Scheduling Jobs to Run Later

Table 20-2 Scheduling Jobs Options

Option Description

Schedule starting from

Select the starting date and time, including the time zone.

Name

Specify a name for the scheduled job; for example, MyDailyCubeRefresh. The name you specify is displayed along with the job name (which you'll choose on the next screen); for example, MyDailyCubeRefresh : Refresh Database.

Recurrence Pattern

Specify the frequency with which to run the job:

  • Hourly: Hourly jobs run according to a timetable which is based on the values you set in the Schedule starting from and Hour fields. The schedule for Hourly jobs restarts each day during the midnight hour and the recurring job starts at the first hour, second hour, third hour (and so on up to 12 hours) after the midnight hour, depending on the value you select in the Hour field.

    So for example, if you specify a value of 5 in the Hour field, the possible times the job could start are during the 12:00 AM hour, the 5:00 AM hour, the 10:00 AM hour, the 3:00 PM hour, and the 8:00 PM hour each day. If the scheduled start time for a job is 12:48 PM and you set the Hourly recurrence for 5 Hours, the job will start at 3:48 PM, which is the first scheduled time available after 12:48 PM in which to start a 5-hour recurring job. Then the job will run again at 8:48 PM, 12:48 AM, 5:48 AM, and 10:48 AM.

    For the default recurrence of 1 Hour, the job will start running at the start time you specify and continue to run each hour until the ending date and time; for example, if the scheduled start time for a job is 12:48, the job will run at 12:48, 1:48, 2:48, 3:48 and so on.

    For a schedule of times based on the values selected in the Hour field, see Scheduling Hourly Jobs.

  • By Minute: Set the Frequency for 15 or 30 minutes. The job will start running in 15 or 30 minutes and continue to run at the selected frequency until the ending date and time; for example, if you set the job to run every 15 minutes and the starting time is 3:15, the job will start to run at 3:30, then 3:45, and so on. Jobs cannot be scheduled to run in increments smaller than 15 minutes.

  • Run Once: The job will run once at the starting date and time.

  • Yearly: The job will run at the starting date and time and continue to run each year thereafter until the end date.

  • Monthly: The job will run at the starting date and time and continue to run each month thereafter until the end date.

  • Weekly: The job will run at the starting date and time and continue to run each week until the end date.

  • Daily: The job will run at the starting date and time and continue to run each day until the end date.

End Date

If the job is recurring, select an ending date and time.