agent-xps-server-configuration-option.md

title	Agent XPs Server Configuration Option | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	configuration
ms.topic	conceptual
helpviewer_keywords	Agent XPs option extended stored procedures [SQL Server], SQL Server Agent
ms.assetid	2e1c6c64-5ce7-4357-98c7-ac7763a9f9de
author	MikeRayMSFT
ms.author	mikeray
manager	craigg

Agent XPs Server Configuration Option

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.

Examples

The following example enables the [!INCLUDEssNoVersion] Agent extended stored procedures.

sp_configure 'show advanced options', 1;  
GO  
RECONFIGURE;  
GO  
sp_configure 'Agent XPs', 1;  
GO  
RECONFIGURE  
GO  

See Also

Automated Administration Tasks (SQL Server Agent)
Start, Stop, or Pause the SQL Server Agent Service