Edit

Share via

Server configuration: Agent XPs

  • Article

Applies to: SQL Server

Use the Agent XPs option to enable the SQL Server Agent extended stored procedures on this server. When this option isn't enabled, the SQL Server Agent node isn't available in SQL Server Management Studio Object Explorer.

When you use the SQL Server Management Studio tool to start the SQL Server Agent service, these extended stored procedures are enabled automatically. For more information, see Surface area configuration.

Note

Management Studio Object Explorer doesn't display the contents of the SQL ServerAgent node unless these extended stored procedures are enabled regardless of the SQL Server Agent service state.

The possible values are:

Value Description
0 (default) SQL Server Agent extended stored procedures aren't available
1 SQL Server Agent extended stored procedures are available

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

Examples

The following example enables the SQL Server 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