Autostarting SQL Agent Service on a cluster

• khatru

  Grasshopper

  Points: 15

  More actions

  August 10, 2005 at 7:25 am

  #89342

  Hi,

  I'm a little confused about where/how to set SQL Agent Service to restart after unexpected failure.

  For a non-clustered instance I'd check the box on the Advanced tab in SQL Server Agent properties.

  In Cluster Manager, the properties of a resource (including the SQL Agent) has a restart field.

  Do these two equate to the same thing?

  At the moment the SQL Agent resource has the default 3 for Restart but Enterprise Manager displays a greyed-out, unchecked box for auto restart.

  I've done quite a bit of trawling but haven't come across anything definitive.

  I'd appreciate your insights on this or links to articles

  Many thanks.

• khatru

  Grasshopper

  Points: 15

  More actions

  August 10, 2005 at 9:19 am

  #581078

  It seems we shouldn't/can't set the SQLAgent service to autorestart. The following is from http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog01.mspx

   

  In addition, in a cluster, do not set SQL Server Agent to restart automatically. If SQL Server Agent is set to restart automatically, it can conflict with the cluster services during a failover.