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 ?
"You can configure SQL Server Agent to restart the SQL Server and SQL Server Agent services automatically if they stop unexpectedly"
Open the SQL Server Management Studio Management folder, right-click the SQL Server Agent entry, and select Properties.
On the General page, select the Auto Restart SQL Server If It Stops Unexpectedly check box.
Here, you should also select the Auto Restart SQL Server Agent If It Stops Unexpectedly check box.
Read more about Configure SQL Server Agent to Restart Services Automatically
Also check Access control lists for the SQL Agent group in case its related.