Restarting SQL Agent automatically (not working)

[Soiboy]

I have set SQL Server Agent to restart automatically if it stops unexpectedly. Unfortunately we have brief power outages, sometimes quite frequently. I take a look at the server after it is restarted and SQL Server Agent is stopped.

I have some fairly critical jobs that need to run on a periodic basis.
Is there any better way to make sure SQL Server Agent stays running or restarts if it stops?

thanks,

Ed

 

[SQLDenis]

How about investing in a UPC device

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[Soiboy]

very funny.
We have UPCs for all the servers.
The problem is when the power outage is too long for the UPCs to handle (small company, no budget).

So is the real answer that SQL Server Agent will not restart even though it is set to start on boot and restart of stopped? Doesn't this setting actually work?

 

[mrdenny]

Set the agent to start automatically instead of manually. The server rebooting will not trigger the agent to start under the "stops unexpectally" method.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mrdenny]

Any by agent I mean the service named SQLSERVERAGENT or SQLAGENT$InstanceName

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Soiboy]

Thanks, I'll check out whether it is set to manual or not, I can't believe I was so stupid to expect it would be auto on boot.

SQLDenis, I have bookmarked your site as well as this one.

 

[mrdenny]

No problem. It's set to manual by default. It has to be changed after SQL is installed.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com