TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Agent XPs Server Configuration Option

 

Updated: July 27, 2016

Applies To: SQL Server 2016

Use the Agent XPs option to enable the SQL Server Agent extended stored procedures on this server. When this option is not enabled, the SQL Server Agent node is not 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.

System_CAPS_ICON_note.jpg Note


Management Studio Object Explorer does not 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:

  • 0, indicating that SQL Server Agent extended stored procedures are not available (the default).

  • 1, indicating that SQL Server Agent extended stored procedures are available.

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

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

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

Community Additions

ADD
Show:
© 2016 Microsoft