'SQL SERVER Agent stops working Automatically

I have been experiencing a strange issue for last few weeks. On my two different servers the sql server Agent stops working automatically, All I have to do is to restart the agent and is back on running. But because it stops working it misses the backup jobs I and few other jobs I have scheduled on them Sql Agents.

It doesn’t happen with any of the other servers but it only happens on these two particular servers.

All the servers are SQL SERVER 2008 R2 , Data Centre Edition. 64-bit.

Has anyone ever experienced the same issue if yes what did you do to resolve it ?

sql-serversql-server-2008-r2sql-agent


Solution 1:[1]

Start > search for "Services", Component Services, locar Services - "SQL Server Agent" in the list, and change Manual to automatic.

It will start the service the service automatically.

Solution 2:[2]

Just to add .02 cents, this was happening to me as well. I figured out that my SQL Server Agent was stopping when my server was automatically restarted for Windows updates. The associated service for the agent was set to restart manually. I went straight to the Windows Services panel (Start > search for "Services"), found "SQL Server Agent" in the list, and set it to start automatically.

Solution 3:[3]

  1. Open The computer Management app
  2. Select services & Applications
  3. Select SQL Server Configuration Manager
  4. Select SQL Server Service (double click)
  5. Select First option SQL Server (MSSQLSERVER)
  6. Right click and go to properties then authenticate
  7. Select this account option and use your sign in credentials to authenticate service Once done service will not drop all good.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 CinCout
Solution 2 hairbo
Solution 3 user19046875

Related Questions