Online Documentation for SQL Backup for SQL Server

Schedule editor


This dialog allows you to create/edit schedule(s).

 

At the Name and Description tab set the name of the schedule and its description.

 

Schedule template - Schedule editor - NameDescription

 

At the General tab of the editor set parameters for the schedule.

 

Create schedule

 

CheckBox Enabled

This option indicates whether schedule is active or not.

 

Schedule type

This section allows you to define schedule type.

 

RadioButton Start automatically when SQL Server Agent starts

This option indicates that tasks associated with this schedule will be launched when SQL Server Agent is started. Select this option to launch tasks associated with this schedule when SQL Server Agent is started.

 

RadioButton Start whenever the CPUs become idle

Use this option to start tasks associated with this schedule whenever CPUs become idle. This option indicates that tasks associated with the schedule will be launched whenever CPUs become idle.

 

RadioButton Start once

This option can be used when a single task performance should be scheduled.

 

RadioButton Recurring from date

Select this option if recurring task performance needed.

 

Frequency

Restrict task execution start and finish date in Occurs (Daily, Weekly, Monthly) from date to date fields and set its interval of recurrence at Recurs every N days.

 

Daily frequency

Set exact time at Occurs once or interval at Recurs every ... from ... to ... for the schedule.

 

NB: When creating the policy you can specify whether local Console or server time will be used for execution.