SQL Server 代理(已禁用代理 XP)

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', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE WITH OVERRIDE
GO

执行sql语句命令---得到如下图片显示---重启---解决


posted @ 2017-01-30 15:05  Z&K  阅读(3907)  评论(0编辑  收藏  举报