By Garth Jones
The SQL Server Agent service is used by SQL Server to execute scheduled tasks. It is typically used for items such as backing up the SQL Server database or other maintenance tasks. By default, this service is not enabled when you install SQL Server. This blog post will show you how to enable this service.
As with any SQL service, you should NOT enable or change them to use the Services Microsoft Management Console (MMC) snap-in; instead, you should use the SQL Server Configuration Manager tool.
1. To start this process on your SQL Server, launch SQL Server Configuration Manager.
2. Right-click the SQL Server Agent service and click Properties.
3. On the Properties Window, select an appropriate account. I will use the Local System account for my example. Then click on the Service tab.
4. Change the Start Mode to Automatic and then click OK to close the window.
5. Right-click the SQL Server Agent service and click Start.
6. With that last step completed, the SQL Server Agent service is ready to be used.
If you have any questions, please feel free to contact me at @GarthMJ.