How to Resolve an Agent XPs Disabled Error
May 15, 2018

The following commands enable Agent XPs within SQL Server, in order to allow you to restart the SQL Agent service;
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