I am unable to start then SQL Server Agent. I am getting the below error message when I tried to start the agent:
The SQL Server Agent service (DB_NN) on local machine was started and then stopped. Some services automatically stop if they are not used by any service or program
- SQL version: SQL Server 2008R2 Standard Edition(RTM)
- Windows:Windows server 2008 R2 enterprise
I verified below things, currently SQL agent is running through service account. I changed to local and tried to start. But agent didn't started.
How to fix this issue?