December 17, 2012 at 9:49 am
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
December 17, 2012 at 9:52 am
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
December 17, 2012 at 3:22 pm
Thanks
December 18, 2012 at 4:58 am
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" 😉
December 18, 2012 at 8:43 am
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
December 18, 2012 at 10:12 am
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" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply