How do we manage the SQL Server Agent Jobs automatically in SQL 2012 when we attempt the Failover between primary and secondary Nodes?
Oct 29, 2012 at 09:24 PM
Mar 15, 2013 at 02:26 PM
Did you get this figured out? If clustering is setup correctly. SQL Agent should be a resource of a node and fail over with the SQL Engine.
Feb 16, 2013 at 01:23 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Oct 29, 2012 at 09:24 PM
Seen: 705 times
Last Updated: Feb 16, 2013 at 01:23 PM
performance degredation at remote node but isolated
Failover clustering of the distributor and subscriber server
SQL Agent CmdExec proxy ignored
Growing working set and private bytes for sqlserver and sql agent
Troubleshooting failover cluster problem in W2K8 / SQL05
SQL Server 2008 failover cluster installation completed with failures
What are the things that a DBA must know about at Windows level that is related to SQL Server and Cluster?
SQL Server 2012 failover cluster - domain groups?
Error during installation of an SQL server Failover Cluster Instance
Where do I install SSRS in a SQL 2012 Cluster?