Execute SQL Server Agent Job Task (Maintenance Plan)
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.
- Connection
Select the server connection to use when performing this task.
- New
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 T-SQL
View the Transact-SQL statements performed against the server for this task, based on the selected options.Note
When the number of objects affected is large, this display can take a considerable amount of time.
New Connection Dialog Box
- Connection name
Enter a name for the new connection.
- Select or enter a server name
Select a server to connect to when performing this task.
- Refresh
Refresh the list of available servers.
- Enter information to log on to the server
Specify how to authenticate against the server.
- Use Windows integrated security
Connect to an instance of the SQL Server Database Engine with Microsoft Windows Authentication.
- Use a specific user name and password
Connect to an instance of the SQL Server Database Engine using SQL Server Authentication. This option is not available.
- User name
Provide a SQL Server login to use when authenticating. This option is not available.
- Password
Provide a password to use when authenticating. This option is not available.
See Also
Other Resources
sp_add_job (Transact-SQL)
How to: Create a SQL Server Agent Job (Transact-SQL)
How to: Create a Job (SQL Server Management Studio)
sp_start_job (Transact-SQL)