通过SSMS看不到SQLAGENT是不稳定的 [英] Unstable to see SQLAGENT through SSMS

问题描述

我有一个Linux安装sql server 2017并启用了sqlagent，但是我无法在ssms中看到代理

I have a Linux install sql server 2017 and have sqlagent enabled, but I am not able to see the agent inside ssms

推荐答案

您将需要sysadmin权限，然后才能看到SQL Agent。您也使用SQL Express版本吗？



另外在linux中： 默认情况下，禁用SQL Server代理。如果mssql.conf设置文件中不存在sqlagent.enabled，则SQL Server在内部假定已禁用SQL Server代理。



启用SQL Server代理：



sudo / opt / mssql / bin / mssql -conf set sqlagent.enabled true 



重启SQL Server服务：



sudo systemctl restart mssql-server



欲了解更多信息，请参考：  ;

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017#agent

You will need sysadmin permissions then only you will be able to see SQL Agent. Also are you using SQL Express edition?

Also in linux :  By default, SQL Server Agent is disabled. If sqlagent.enabled is not present in the mssql.conf settings file, then SQL Server internally assumes that SQL Server Agent is disabled.

Enable the SQL Server Agent:

sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true 

Restart the SQL Server service:

sudo systemctl restart mssql-server

For more information you can refer: 
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017#agent

最好的问候，

Best Regards,

Ujjwal Patel。

Ujjwal Patel.

 

请记得单击"标记为答案"以解决您的问题，并点击"取消标记为答案"，如果没有。这对其他社区
成员阅读此主题有益。

Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.

这篇关于通过SSMS看不到SQLAGENT是不稳定的的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！