Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Use the Execute SQL Server Agent Job Task dialog to execute Microsoft SQL Server Agent jobs within a maintenance plan. This option will not be available if you have no SQL Server Agent jobs on the selected connection.
This task uses the .sp_start_job statement.
Select the server connection to use when performing this task.
Create a new server connection to use when performing this task. The New Connection dialog box is described below.
Available SQL Agent jobs
Select the job to execute. The grid provides the Job name and Description to identify the jobs.
View the Transact-SQL statements performed against the server for this task, based on the selected options.
When the number of objects affected is large, this display can take a considerable amount of time.