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

How to avoid the SQL Server Agent to start on a SQL server Failover Expand / Collapse
Author
Message
Posted Monday, December 17, 2012 9:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 1:39 PM
Points: 127, Visits: 300
Hi,
I'm wondering how can I avoid the SQL server Agent to start o SQL Server failover cluster. I changed the start mode to disabled but I haven't checked doing the failover. Will it work this way?

On the case of a SQL server stand alone should it be ok doing the same change. I know that changing the start mode to manual will work on an stand alone but it will be good to know on Failover.

Thanks!!!!!
APA
Post #1397327
Posted Monday, December 17, 2012 9:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:09 PM
Points: 13,872, Visits: 9,597
Don't set up SQL agent to be cluster aware, and set it up with manual startup or disabled.

I'm not sure why you'd want it this way, but it will work.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1397330
Posted Monday, December 17, 2012 3:22 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 1:39 PM
Points: 127, Visits: 300
Thanks
Post #1397445
Posted Tuesday, December 18, 2012 4:58 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:28 PM
Points: 6,518, Visits: 14,038
APA0876 (12/17/2012)
Hi,
I'm wondering how can I avoid the SQL server Agent to start o SQL Server failover cluster. I changed the start mode to disabled but I haven't checked doing the failover. Will it work this way?

On the case of a SQL server stand alone should it be ok doing the same change. I know that changing the start mode to manual will work on an stand alone but it will be good to know on Failover.

Thanks!!!!!
APA

Failover cluster manager knows the state of each clustered resource. Manually stopping a clustered service should leave it offline until you restart it. The SQL Server service and its agent should be set to manual startup initially so that they fall under Failover cluster manager control. You could disable it but manually stopping it via the cluster admin tools would be better.

Incidentally, why don't you want the agent service to start, any particular reason?


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1397699
Posted Tuesday, December 18, 2012 8:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 1:39 PM
Points: 127, Visits: 300
Hi, this instance is an old production Box, so we do not want the jobs to execute accidentally as we did not disable them before we stop the agent so we are affraid that the agent start and some of the jobs execute. Either way we will disable some linked servers to avoid jobs actions to distrubute to other servers

Thanks
Post #1397852
Posted Tuesday, December 18, 2012 10:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:28 PM
Points: 6,518, Visits: 14,038
Killing the agent is bit like using a sledge hammer to crack a nut. Just disable the jobs that you don't want to run!

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1397904
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse