Online Documentation for SQL Administrator for SQL Server

Schedule Editor


The Add New Job Schedule / Edit Schedule dialog allows you to define schedule parameters.

 

Schedule Editor - Editing schedule definition

 

 

Use the Schedule tab of Schedule Editor to configure/view schedule properties.

 

Name

Enter a name for the new schedule, or modify the name of the schedule being edited. Enable/disable the schedule using the !CheckBox Enabled option.

 

Specify the Execution Type of the schedule indicating when the scheduled job is to be executed:

!RadioButton Start when SQL Server Agent starts

!RadioButton Start when CPUs idle

!RadioButton Start at time... (set the date using the date editor which is activated when you click the Arrow-Down element of the combo-box; specify the time value using the spinner control)

!RadioButton Run recurrently

 

If the Recurrent execution type is selected, you should also set the Recurrence, Daily Frequency and Duration properties of the current schedule.

 

The Recurrence area allows you to specify the daily/weekly/monthly recurrence rule, define the Recurs Every ... days/weeks value, and select the days of the week/month that can be set for the schedule.

 

The Daily Frequency tab allows you to select whether the scheduled job will be run once at ... or every ... hours/minutes start at ... end at ... (specify the day/time values using the drop-down menu and spinner controls).

 

The Duration tab allows you to set the Start date and the End date threshold values for the interval using the date editor which is activated when you click the Arrow-Down element of the combo-box.

 

!CheckBox No end date

Check this option if you are uncertain when the scheduled job should be finished, or if no limitations on the job duration are required.