Skip to content

Latest commit

 

History

History
56 lines (43 loc) · 2.67 KB

agent-xps-server-configuration-option.md

File metadata and controls

56 lines (43 loc) · 2.67 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Server configuration: Agent XPs
Discover how to use the Agent XPs option to enable SQL Server Agent extended stored procedures. View an example that uses this option.
rwestMSFT
randolphwest
07/18/2024
sql
configuration
conceptual
Agent XPs option
extended stored procedures [SQL Server], SQL Server Agent

Server configuration: Agent XPs

[!INCLUDE SQL Server]

Use the Agent XPs option to enable the [!INCLUDE ssNoVersion] Agent extended stored procedures on this server. When this option isn't enabled, the [!INCLUDE ssNoVersion] Agent node isn't available in [!INCLUDE ssManStudioFull] Object Explorer.

When you use the [!INCLUDE ssManStudioFull] tool to start the [!INCLUDE ssNoVersion] Agent service, these extended stored procedures are enabled automatically. For more information, see Surface area configuration.

Note

[!INCLUDE ssManStudio] Object Explorer doesn't display the contents of the [!INCLUDE ssNoVersion]Agent node unless these extended stored procedures are enabled regardless of the [!INCLUDE ssNoVersion] Agent service state.

The possible values are:

Value Description
0 (default) [!INCLUDE ssNoVersion] Agent extended stored procedures aren't available
1 [!INCLUDE ssNoVersion] Agent extended stored procedures are available

The setting takes effect immediately without a server stop and restart.

Examples

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

  1. Connect to the Database Engine from Microsoft SQL Server Management Studio.
  2. Select New Query from the menu.
  3. Copy and paste the following example into the query window, and select Execute.
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO

Related content