Online Documentation for SQL Manager for SQL server

Setting schedule options


Using this step you can create a scheduled backup by selecting the RadioButton Create schedule option and defining the scheduling parameters.

 

Schedule name

Enter a name of the new backup schedule.

 

CheckBox Enabled

Check this option to enable the scheduled backup immediately after its creation.

 

Backup Database - Setting schedule options

 

 

Execution Type

 

This panel allows you to define the execution behavior of the schedule:

 

RadioButton Start when SQL Server Agent starts

The scheduled backup operation will be started each time upon the SQL Server Agent startup.

 

RadioButton Start when CPU usage is low

The scheduled backup operation will be started each time when the CPU usage is low.

 

RadioButton Start once on...

The scheduled backup operation will be started only once on the defined date at the specified time.

 

RadioButton Recurrent Execution

The scheduled backup operation will be started recurrently.

 

The following tabs allow you to setup the schedule routine:

 

Recurring Interval

This tab allows you to set the schedule recurrence periodicity in days: you can run your schedule daily, weekly, monthly, every several days, or on a certain day(s) of the week.

 

Daily Frequency

This tab allows you to set the schedule recurrence periodicity in hours: you can run your schedule once at a specified time, or run it every few hours or minutes after the specified interval.

 

Duration

This tab allows you to set the schedule lifetime: you can set the schedule start date and the expiration date in the respective edit fields.

 

 

Click the Next button to proceed to the Setting media options step of the wizard.