SQL SERVER – Server Configurations Options – Agent XPs Option

The Server configuration option called Agent XPs is used to enabled the SQL Server Agent extended stored procedures on the server. When this option is disabled, the SQL Server Agent node is not enabled in SQL Server Management Studio and you can not use the SQL Server Agent Service.

When the SQL Server agent is restarted, the extended stored procedures are enabled automatically.

To enabled this option:

sp_configure 'show advanced options', 1

GO

RECONFIGURE with override

GO

sp_configure 'Agent XPs', 1

GO

RECONFIGURE with override

GO

sp_configure 'show advanced options', 0

GO

RECONFIGURE with override

GO

This option is an advanced option and is necessary enable first the “show advanced options”. To understand in a better way if a certain option is or is not advanced, if it is dynamic or is necessary restart, please refer SQL SERVER – Server Configurations Options – Catalog View – sys.configurations