SQL Agent 显示 "SQL Agent XPs Disabled"但它们不是

Question

SQL Server 2012 SP2 CU6 v-5592

我启动 SQL 服务和 SQL 代理服务；都开始OK。然后我在 Windows 2012 Ent(不是 R2)服务器上登录 SSMS，SQL Agent 有红色 X 并在 SSMS 中显示为“SQL Agent XPs Disabled”，我只需在对象资源管理器中右键单击服务器上的刷新，一切正常

重新运行 reconfigure = 1 和同样的事情；说已经设置为 1

两个相同的服务器；同一天安装，一个安装，一个不安装。

为什么说 Disabled 而不是呢？我的工作会失败吗？我该如何摆脱它？

Answer 1

只执行这个

USE MASTER DATABASE 
    declare @agent_enabled bit
    declare @show_advanced bit
    select @show_advanced = cast(value_in_use as bit)
    from sys.configurations where name = N‘show advanced options’
    select @agent_enabled = cast(value_in_use as bit)
    from sys.configurations where name = N‘Agent XPs’
    if 0 <> @agent_enabled
    begin
    if 1 <> @show_advanced
    begin
    exec sys.sp_configure @configname = N‘show advanced options’, @configvalue = 1
    reconfigure with override
    end
    exec sys.sp_configure @configname = N‘Agent XPs’, @configvalue = 0
    reconfigure with override
    if 1 <> @show_advanced
    begin
    exec sys.sp_configure @configname = N‘show advanced options’, @configvalue = 0
    reconfigure with override
    end
    end

---

然后去

Start -> Control Panel -> Administrative Tools -> Services (double click)->SqlServerAgent(MSSQLSERVER)-> Start(right click)