SQL Server Agent (Agent XPs disabled)

How to enable Agent XPs when SQL Agent Service shows "(Agent XPs disabled)".

From SQL Server Management Studio, open query window and use sp_configure commands below:

SP_CONFIGURE 'SHOW ADVANCE',1

GO

RECONFIGURE WITH OVERRIDE

GO

SP_CONFIGURE 'AGENT XPs',1

GO

RECONFIGURE WITH OVERRIDE

GO

Start or restart SQL Agent in SSMS.

Reference:

https://blog.sqlauthority.com/2016/06/13/sql-server-fix-agent-xps-component-turned-off-part-security-configuration-server/

https://blog.sqlauthority.com/2016/02/29/sql-server-unable-to-start-sql-server-agent-failed-to-initialize-sql-agent-log/