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.

%d bloggers like this:

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close