Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Installing SQL Server Agent on Ubuntu Server


By:   |   Read Comments   |   Related Tips: More > SQL Server on Linux

Problem

In a previous tip I explained how to install SQL Server vNext on Ubuntu Linux server. Please have a look to get the background of SQL Server running on Ubuntu. Here I will explain how to install SQL Server Agent on an Ubuntu server, so that we can create SQL Server Agent Jobs to schedule repetitive tasks.

Solution

Recently, Microsoft released the updated version of SQL Server vNext CTP for Linux based operating systems. The latest version for SQL Server vNext is CTP 1.4. This update of SQL Server brings SQL Server Agent support to make a DBA's life easy. You can get the full list of features supported and learn about known issues of this version from this Microsoft link: SQL Server on Linux Release Notes.

SQL Server Agent Installation on Ubuntu Server

Before going ahead, you need to have SQL Server vNext running on an Ubuntu Server where we will install SQL Server Agent. I have followed the step by step method from Microsoft's online documentation to understand this installation. Let's start the SQL Server Agent installation on the Ubuntu Server.

Step 1: First, connect to the Ubuntu Server either using PuTTY or directly login to the Ubuntu server using a valid username and password. I used PuTTY to connect to the server.

connect to Ubuntu Server

You can see we have connected to our target machine where we are going to install SQL Server Agent.

Step 2: As per Microsoft, we need to have SQL Server CTP 1.4 to install SQL Server Agent whereas our SQL Server vNext is still running on CTP1.1. So first we need to upgrade to CTP 1.4 which configures the keys and repositories that we need when we install the mssql-server-agent package. Let's check the existing version of SQL Server installed on our Ubuntu server.

SQL Server Version on ubuntu

Step 3: We can see the version installed on this Ubuntu server is CTP 1.1, so we will start the upgrade process to bring this SQL Server to CTP 1.4 in order to install SQL Server Agent.

We will run the "sudo apt-get update" command to resynchronize the package index files from the their sources specified in /etc/apt/sources.list file. The update command fetched the packages from their locations and updates the packages to the newer version. Run the below command to update the source list.

#resynchronize the package index files
sudo apt-get update

Execution will start with a series of package updates. Once execution is successful, the next step is to install the latest update of SQL Server vNext.

sudo apt-get update

Step 4: Now we will upgrade SQL Server vNext to bring it to version CTP 1.4. Run the below command to start the process. This command will download the newest package and replace the binaries located under /opt/mssql/. The user generated databases and system databases will not be affected by this operation, but make sure to keep a backup of everything hosted on your SQL Server to be safe.

#Upgrade SQL Server
sudo apt-get install mssql-server

upgrade sql server vNext

Once the above command executes successfully we can check the latest version of SQL Server.

You can see the SQL Server version has now changed to CTP 1.4 in the below picture. Our next step is to install SQL Server Agent on this box.

Check sql server vNext version

Step 5: In order to install SQL Server Agent on your Ubuntu server, first you need to run "sudo apt-get update" to resynchronize the package index files from the their sources. As I have already updated these files, it is not mandatory for me to perform this action, but if you are already running with SQL Server vNext 1.4 version then you should run this command to get the latest files. Run the below command if you have not updated the package repositories.

sudo apt-get update

The apt-get update downloads the package lists from the repositories and "updates" them to get information on the newest versions of packages and their dependencies.

apt-get update

Step 6: Once the above command executes successfully, the next step is to install SQL Server Agent on Ubuntu. Run the below command to kick off the SQL Server Agent installation on this machine.

#Install SQL Server Agent
sudo apt-get install mssql-server-agent

Once you press enter to execute the above command, the execution process will start to install the package. Once installation is successful, you will get the below screen to proceed with the next step.

install SQL Server Agent

You can notice there is an instruction showing in the dashed rectangle box in the above screenshot that says "Please restart mssql-server to enable Microsoft SQL Server Agent". So our next step is to restart this service to complete the installation.

Step 7: Run the below command to restart the SQL Server service and then check the status of this service to validate the restart step.

#Restart SQL Server service
systemctl restart mssql-server

#check the status of mssql-server service.
systemctl status mssql-server

After the SQL Server service status has been restarted, we are done with the SQL Server Agent installation on the Ubuntu server. Now go ahead and configure SQL Server Agent Jobs on SQL Server vNext. In my next article, I will explain how to create jobs.

restart sql server service

Step 8: If you want to validate that SQL Server Agent is running on this server, you can connect to the SQL Server instance using SSMS and expand the SQL Server Agent folder. You will see all SQL Server Agent subfolders as shown below.

validate the installation of SQL Server Agent
Next Steps
  • The next step is to start configuring SQL Server Agent Jobs as per your needs.
  • I will explain the step by step process of SQL Server Agent job creation on a Linux server in my next tip.
  • Explore more knowledge on SQL Server Database Administration Tips.


Last Update:






About the author
MSSQLTips author Manvendra Singh Manvendra Singh has over 5 years of experience with SQL Server and has focused on Database Mirroring, Replication, Log Shipping, etc.

View all my tips
Related Resources





More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools