Here are the steps to Start SQL Server Agent service using SQL Server Configuration Manager. Using SQL Server Configuration Manager, you can also set Agent Service startup parameters like changing service startup account
1) Launch SQL Server Configuration Manager
In Windows desktop, click on Start –> All Programs –> Microsoft SQL Server 2008 R2 –> SQL Server Configuration Manager
2) View SQL Agent Service properties
On left pane, click on “SQL Server Services”; on right pane, you will see all installed instances of SQL Sever components.
To View SQL Server Agent properties, double click on SQL Server Agent ( MSSQLSERVER) entry on left pane. You will see a property dialog
3) Set SQL Agent Service start up mode = “Automatic”.
By setting service startup mode to “Automatic” SQL Agent service is started up when machine starts up. Select “Automatic” from drop down next to Startup Mode setting; click “Ok”
4) Start SQL Agent Service
Select “SQL Server Agent Service ( MSSQLSERVER )” entry on right pane. Right click on right pane in SQL Server configuration Manager; click on “Start” menu
5) Verify SQL Server Agent service is running
Click on menu Action –> Refresh; On right pane, check SQL Server Agent’s service state as “Running”.
This posting is provided “AS IS” with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm