Wayne Sheffield

My blog about SQL Server

Browsing Posts tagged Availability Group

Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.

When you have an Availability Group, you will end up with jobs that you want to run only on the primary replica. Yet, the job should be installed identically on all replicas. This post shows several methods of creating primary replica jobs that will only run on the primary replica.