How to Install SQL Server Agent on Windows?

SQL Server Agent is a component of Microsoft SQL Server. It schedules jobs and handles other automated task on a database.
This windows service can automatically start when we boot up the system or set it up manually. SQL Server Agent enables us to automate all the task which are repetitive in nature and is done regularly as scheduled jobs. This saves lots of time and effort and makes the process more efficient. SQL server agent is used to run T-SQL jobs ( Transact SQL), stored procedures (saved SQL code which can be used again), SSIS (SQL Server Integration Services) packages, and SSAS (SQL Server Analysis Services) databases.

Steps to Install SQL Server Agent on Windows

SQL Server Agent is a job scheduler service within SQL Server, You do not need a separate package, hence we need to install SQL server to get this service activated. SQL server has Express, Developer, Standard, Enterprise, and Web edition versions. Express edition doesn’t support SQL server agents. For our purpose, we will download the “Developer” version.

Step 1: Go to your favorite browser like Chrome and search for Download SQL server from the internet.

Step 2: Open the link and Scroll down. Click open the Developer “Download Now” button. 

Step 3: Run the .exe file and follow the wizard to install the SQL server. Selecting Basic Installation. 

SQL Server comes with 3 different profiles as shown above, for personal use, chose basic. Accept Microsoft SQL server license terms by clicking accept the option.

Step 4: Downloading & Completed Installation.

After the successful download of the SQL server, installation starts.

As shown in the image below, the installation of the SQL server is successfully completed.

Step 5: Click “Install SSMS” and that opens a webpage to download the package.

Step 6: Click the link to download. SSMS-Setup-ENU.exe is in the downloads folder. Run the .exe file and we get the installation window.

The installation is in process.

Step 7: Done Installation with confirmation screenshot below.

Step 8: Close the above window and let’s validate.

Step 9: Go to the Start menu, Open “SQL Server Management Studio (SSMS)”. Click connect 

Step 10: SSMS is connected and SQL Server Agent is listed on the left side of the screen below. 

Step 11: Enable SQL Server Agent by right-clicking on the same icon and clicking “Start”

Summary

Download and Install SQL Server >> Install SSMS (SQL Server Management Studio) >> SQL Server Agent is ready