To see the state of “Agent XPs” option, run the folowing code:
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Agent XPs'
To enable the SQL Server Agent extended stored procedures:
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Agent XPs', 1
GO
RECONFIGURE
GO
The setting takes effect without a server restart.
To see the state of “Agent XPs” option again:
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Agent XPs'
Refresh Management Studio Object Explorer…
No comment