已禁用代理xp 解决办法

Sql代码 
sp_configure 'show advanced options', 1;   
GO   
RECONFIGURE WITH OVERRIDE;   --加上WITH OVERRIDE   
GO   
sp_configure 'Agent XPs', 1;   
GO   
RECONFIGURE WITH OVERRIDE     --加上WITH OVERRIDE   
GO 
sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;   --加上WITH OVERRIDE
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE WITH OVERRIDE     --加上WITH OVERRIDE
GO

原文地址:https://www.cnblogs.com/zcm123/p/9420897.html