title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Execute SQL Server Agent Job Task (Maintenance Plan) |
Execute SQL Server Agent Job Task (Maintenance Plan) |
MikeRayMSFT |
mikeray |
randolphwest |
03/27/2023 |
sql |
supportability |
conceptual |
|
|
[!INCLUDE SQL Server]
Use the Execute SQL Server Agent Job Task dialog to execute Microsoft SQL Server Agent jobs within a maintenance plan. This option isn't 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 [!INCLUDEtsql] 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.
-
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 [!INCLUDEssNoVersion] [!INCLUDEssDE] with [!INCLUDEmsCoName] Windows Authentication.
-
Use a specific user name and password
Connect to an instance of the [!INCLUDEssNoVersion] [!INCLUDEssDE] using [!INCLUDEssNoVersion] Authentication. This option isn't available.
-
User name
Provide a [!INCLUDEssNoVersion] login to use when authenticating. This option isn't available.
-
Password
Provide a password to use when authenticating. This option isn't available.