Steps to enable the ‘Agent XPs’
— To enable the avdanced options
EXEC SP_CONFIGURE ‘show advanced options’,1
GO
RECONFIGURE
GO
EXEC SP_CONFIGURE ‘show advanced options’
–To check the current run value of Agent XPs. run_value 0 indicates disabled and 1 for enabled.
exec sp_configure ‘Agent XPs’
— To enable the Agent Xps.
EXEC SP_CONFIGURE ‘Agent XPs’,1
GO
RECONFIGURE
—- END
In few cases even after enabling the Agent XPs, we face below error.
Error: Unable to start service SQLSERVERAGENT on server dbserver12. (mscorlib)
Fix: change the password of agent services account or change the agent services account.