question

princepandey avatar image
princepandey asked

Manage sql server agents jobs

How do we manage the SQL Server Agent Jobs automatically in SQL 2012 when we attempt the Failover between primary and secondary Nodes?
sql-server-2012clustersql-agentfailover
10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
sqlaj 1 avatar image
sqlaj 1 answered
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.
10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.