Friday, February 01, 2013

SQL Server Agent (Agent XPs disabled)

Error in SQL Server Jobs:
SQL Server blocked access to procedure 'dbo.sp_get_sqlagent_properties' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online.

Resolve by:
sp_configure 'show advanced options', 1; GO;
RECONFIGURE; GO;
sp_configure 'Agent XPs', 0; GO;
RECONFIGURE; GO;

Share Links