Agent XPs Option

  • Article

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 Surface Area Configuration tool to start the SQL Server Agent service, these extended stored procedures are enabled automatically. For more information, see Surface Area Configuration.

Note

SQL Server Management Studio Object Explorer does not display the SQL Server Agent 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.

Examples

The following example enables the SQL Server Agent extended stored procedures.

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

See Also

Tasks

How to: Start SQL Server Agent (SQL Server Configuration Manager)
How to: Start SQL Server Agent (net Commands)

Other Resources

Automating Administrative Tasks (SQL Server Agent)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

5 December 2005
Changed content:
  • Added clarification that the SQL Server Agent extended stored procedures are automatically enabled when the Surface Area Configuration tool is used to start the SQL Server Agent service.