Online Documentation for SQL Administrator for SQL Server

Execute job


Use the Execute Job Task dialog to execute Microsoft SQL Server Agent jobs within a maintenance plan. This option  is not available if you have no SQL Server Agent jobs on the selected connection.

The General tab allows you to set common properties for this task. To set relationships between tasks use the Precedence constraints tab.

 

Maintenance plans - Maintenance Plan Editor - Managing tasks - Execute job

 

 

Name

Enter the task name.

 

Enabled

Check this option to enable task execution.

 

Connection

Specify which server connection should be used for task execution. You can choose among existing connections or create a new one.

 

Job to execute

Use the drop-down list to specify the SQL Agent job to execute during the task. The list provides the Job name and Description to identify the jobs. To edit the selected job properties press the OpenInEditor button.

You can also create a new job in the Job Editor by clicking the AddJobCategory button.

 

 


See also:

Backup database

Check database

Rebuild indexes

Reorganize indexes

Shrink database

Update statistics

Execute T-SQL statement

Notify operator

Clean up history

Clean up maintenance log

Precedence constraints