Install SQL Server Agent on Linux
Applies to: SQL Server - Linux
This article describes how to enable or install the SQL Server Agent on Linux.
The SQL Server Agent runs scheduled SQL Server jobs. Starting with SQL Server 2017 (14.x) CU 4, SQL Server Agent is included with the mssql-server package and is disabled by default. For information on the features supported for this release of the SQL Server Agent along with version information, see Release notes for SQL Server 2017 on Linux.
Instructions
Before using the SQL Server Agent on Linux, use the following steps to enable or install it.
Add your hostname (with and without domain) in the
/etc/hosts
files. The following lines show an example of the format for these entries:"IP Address" "hostname" "IP Address" "hostname.domain.com"
Follow the instructions in one of the following sections based on your version of SQL Server:
Versions Instructions SQL Server 2017 (14.x) CU 4 and later versions Enable the SQL Server Agent SQL Server 2017 (14.x) CU 3 and earlier versions Install the SQL Server Agent
Enable the SQL Server Agent
For SQL Server 2017 (14.x) CU 4 and later versions, you only need to enable the SQL Server Agent. You don't need to install a separate package.
To enable SQL Server Agent, follow these steps.
sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true
sudo systemctl restart mssql-server
If you upgrade from SQL Server 2017 (14.x) CU 3 or an earlier version with Agent installed, SQL Server Agent is enabled automatically, and previous Agent packages are uninstalled.
Note
SQL Server Management Studio Object Explorer doesn't display the contents of the SQL Server Agent node unless the Agent XPs (server configuration option) is enabled, regardless of the SQL Server Agent service state.
Install the SQL Server Agent
For SQL Server 2017 (14.x) CU 3 and earlier versions, you must install the SQL Server Agent package.
The following installation instructions apply to SQL Server 2017 (14.x) CU 3 and earlier versions only. Before you install SQL Server Agent, first install SQL Server, which configures the keys and repositories you need when you install the mssql-server-agent package.
Install the SQL Server Agent for your platform.
Use the following steps to install the mssql-server-agent on Red Hat Enterprise Linux.
sudo yum install mssql-server-agent
sudo systemctl restart mssql-server
If mssql-server-agent is installed, you can update to the latest version with the following commands:
sudo yum check-update
sudo yum update mssql-server-agent
sudo systemctl restart mssql-server
If you need an offline installation, locate the SQL Server Agent package download in the Release notes for SQL Server 2017 on Linux. Then use the same offline installation steps described in the article Install SQL Server.
Related content
Зворотний зв’язок
https://aka.ms/ContentUserFeedback.
Очікується незабаром: протягом 2024 року ми будемо припиняти використання механізму реєстрації проблем у GitHub для зворотного зв’язку щодо вмісту й замінювати його новою системою зворотного зв’язку. Докладніше:Надіслати й переглянути відгук про