| title | Agent XPs Server Configuration Option | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/02/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.service | |||
| ms.component | configure-windows | ||
| ms.reviewer | |||
| ms.suite | sql | ||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | article | ||
| helpviewer_keywords |
|
||
| ms.assetid | 2e1c6c64-5ce7-4357-98c7-ac7763a9f9de | ||
| caps.latest.revision | 24 | ||
| author | MikeRayMSFT | ||
| ms.author | mikeray | ||
| manager | craigg | ||
| ms.workload | On Demand |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
Use the Agent XPs option to enable the [!INCLUDEssNoVersion] Agent extended stored procedures on this server. When this option is not enabled, the [!INCLUDEssNoVersion] Agent node is not available in [!INCLUDEssManStudioFull] Object Explorer.
When you use the [!INCLUDEssManStudioFull] tool to start the [!INCLUDEssNoVersion] Agent service, these extended stored procedures are enabled automatically. For more information, see Surface Area Configuration.
Note
[!INCLUDEssManStudio] Object Explorer does not display the contents of the [!INCLUDEssNoVersion]Agent node unless these extended stored procedures are enabled regardless of the [!INCLUDEssNoVersion] Agent service state.
The possible values are:
-
0, indicating that [!INCLUDEssNoVersion] Agent extended stored procedures are not available (the default).
-
1, indicating that [!INCLUDEssNoVersion] Agent extended stored procedures are available.
The setting takes effect immediately without a server stop and restart.
The following example enables the [!INCLUDEssNoVersion] Agent extended stored procedures.
-
From Microsoft SQL Server Management Studio connect to the Database Engine.
-
From the Standard bar, click New Query.
-
Copy and paste the following example into the query window and click Execute.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO Automated Administration Tasks (SQL Server Agent)
Start, Stop, or Pause the SQL Server Agent Service