Online Documentation for SQL Manager for SQL server

Setting schedule properties


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.

 

Schedule Editor - Editing schedule definition

 

 

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 CPU usage is low

RadioButton Start once on... (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 Recurrent execution

 

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

 

The Recurring Interval tab allows you to specify the daily/weekly/monthly recurrence rule, define the 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 from ... to ... (specify the day/time values using the drop-down menu and spinner controls).

 

Schedule Editor - Editing schedule definition - Daily frequency

 

 

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.

 

Schedule Editor - Editing schedule definition - Duration

 

 

 

CheckBox Unlimited

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