Skip to content

agent-xps-server-configuration-option.md

Latest commit

 

History

History
59 lines (45 loc) · 2.93 KB

agent-xps-server-configuration-option.md

File metadata and controls

59 lines (45 loc) · 2.93 KB
title Agent XPs Server Configuration Option | Microsoft Docs
description Discover how to use the Agent XPs option to enable SQL Server Agent extended stored procedures. View an example that uses this option.
ms.custom
ms.date 03/02/2017
ms.prod sql
ms.prod_service high-availability
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 markingmyname
ms.author maghan

Agent XPs Server Configuration Option

[!INCLUDE SQL Server]

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.

Example

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

  1. From Microsoft SQL Server Management Studio connect to the Database Engine.

  2. From the Standard bar, click New Query.

  3. 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

See Also

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