Restart SQL Server Agent automatically if it stops

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Uni - 25 Jan 2006 17:52 GMT

I had an earlier post about the SQL Server Agent on a SQL cluster
stopping every now and then.

I noticed that there is an option under SSA properties to "Restart
Agent if it stops", but it's greyed out.

Anyone know how I can have the Agent restart itself if it stops?

I think the cluster service controls it, so is it possible?

Reply to this Message

Uni - 25 Jan 2006 18:01 GMT

We used RAID10 on our Cluster for high availability and speed.

Reply to this Message

Rodney R. Fournier [MVP] - 25 Jan 2006 18:07 GMT

All clustered services are set to Manual and should remain that way. The
cluster should handle starting and stopping of the SQL Agent. Look at the
properties of the SQL Agent resource within the cluster - Advanced tab -
restart options. Are they set properly?

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training

>I had an earlier post about the SQL Server Agent on a SQL cluster
> stopping every now and then.
[quoted text clipped - 5 lines]
>
> I think the cluster service controls it, so is it possible?

Reply to this Message

Uni - 26 Jan 2006 00:46 GMT

I noticed those settings. Yes, they are set to the default, which is
to restart the Service automatically.

Reply to this Message

Anthony Thomas - 26 Jan 2006 03:10 GMT

In fact, the last entries from the startup process in the SQL Agent logs
states this explicitly, THIS IS A CLUSTERED CONFIGURATION, THE AUTO RESTART
SETTING WILL BE IGNORED.

Yes, you have to control this from the Cluster Administrator settings for
the restart.

Sincerely,

Anthony Thomas

> I noticed those settings. Yes, they are set to the default, which is
> to restart the Service automatically.

Reply to this Message