Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Uncluster Agent, set to automatic on each node in a 2 node failover cluster. Expand / Collapse
Author
Message
Posted Friday, December 6, 2013 11:02 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:27 AM
Points: 87, Visits: 543
We are having trouble with SQL Agent in a cluster, on one node it doesn't start. I have not been involved in the root-cause analysis, but I was thinking of unclustering Agent. Never done it before.

What is the impact of running agent on each node with automatic, so its running on both servers.

So, when SQL Server is running on Node 1, executing jobs, then fails over to Node 2, can't it just use the Agent service running on that server instead?

Thanks.
Post #1520684
Posted Friday, December 6, 2013 11:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:19 AM
Points: 6,177, Visits: 13,322
what errors are you receiving when you try to start the agent?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1520692
Posted Friday, December 6, 2013 12:42 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
My first thought was, no way would I do this. If the Agent is running on both then it you have no way of know which one will run a job, I think there is also a question about concurrency, what happens if BOTH start a job. I can't think of anything good to come from this..

I think we need to know what errors you are getting.

Worst case is uninstall that SQL instance (yielding a single node cluster), and then re-install it. You lose the second node for THAT instance for a bit but then you get it back..

CEWII
Post #1520712
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse