当前位置: 代码迷 >> 综合 >> MSSQL2019+Linux7, The SQLServerAgent is not currently running, so it cannot be notified of this
  详细解决方案

MSSQL2019+Linux7, The SQLServerAgent is not currently running, so it cannot be notified of this

热度:80   发布时间:2024-02-28 11:54:54.0

MSSQL2019 for Linux7.7, The SQLServerAgent is not currently running, so it cannot be notified of this action. error:22022 

检查发现主机名带有.local域名,应该和这有关

[root@oem mssql]# hostnamectl set-hostname oem

[root@oem mssql]# hostname                        
oem

[root@oem mssql]# vi /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.52.129 oem
192.168.52.146 win2012.local
192.168.52.129 oem.local

[root@oem mssql]# systemctl restart mssql-server.service

重启服务后再次执行作业job成功。

参考:

https://docs.microsoft.com/en-us/answers/questions/96464/mssql2019-for-linux-the-sqlserveragent-is-not-curr-1.html

  相关解决方案