Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
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.
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.