Install SQL Server Agent on Ubuntu (Linux)

, 2017-06-16

With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to schedule any task using a SQL Server Agent Job on Linux machine. In this post, I will explain how to install the SQL Server Agent package on the Ubuntu system.

Before you start installation SQL Server Agent, you need to have SQL Server vNext running on a Ubuntu System. To show the SQL Server Agent package installation process, I will be using SQL Server  2017 (CTP 2.1) instance which is running on the Ubuntu system. 

In the below image, you can see that the SQL instance is running on the Ubuntu system. But, the SQL Server Agent is showing disabled because the SQL Server Agent package is not installed on the Ubuntu server.

Install SQL Server Agent

  • Connect to your Ubuntu Linux Server either using PuTTY or directly login to the server by keying a valid username and password.

  • Switch to root user (superuser)

Syntax: sudo su

  • Run the below script to get all the latest updates from Ubuntu online servers

Syntax: sudo apt-get update

  • Install the SQL Server Agent on the machine now

Syntax: sudo apt-get install mssql-server-agent

  • Once you install the SQL Server Agent package successfully, you need to restart the SQL Server to enable the SQL Server Agent.

Syntax: sudo systemctl restart mssql-server

  • Reconnect/Refresh the SQL Server instance to check the current status of SQL Server Agent.

You have successfully install the SQL Server Agent package on the Ubuntu System.

Note:- The following components and subsystems of SQL Agent jobs are not currently supported on Linux SQL Server  2017 (CTP 2.1):

Subsystems: CmdExec, PowerShell, Replication Distributor, Snapshot, Merge, Queue Reader, SSIS, SSAS, SSRS
Alerts
DB Mail
Log Reader Agent
Change Data Capture

Hope, you enjoyed the SQL Server Agent package installation processes!!!

The post Install SQL Server Agent on Ubuntu (Linux) appeared first on .

Rate

Share

Share

Rate

Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

2009-02-23

1,567 reads

Networking - Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...

2009-02-17

1,530 reads

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.

2009-02-13

360 reads