This is part 5 in the series of how to replicate SQL Jobs between instances and we’re finally up to the part that actually replicates the jobs. To get the background and all the steps you need to do before this one, go and read the other posts first.
This is part 4 on the series of how to replicate SQL Jobs between instances. Previously I’ve covered why replicate, setting up and replicating categories. The next item to replicate is Schedules.
Conceptually, replicating jobs between servers is straight forward. There are 2 things to do: If the job doesn’t exist, create it; and If the job exists, check that it’s the same, and if not, update it We don’t have a requirement to delete extra jobs, but that would add a simple third step. The problem with SQL Jobs […]
After deciding to replicate SQL Agent Jobs between SQL Instances using a SQL Agent job, there were a few things to setup and test. We need a way to check if the server is the primary in the AlwaysOn Availability Group, so that jobs can decide if they need to run; We needed a way […]
We use SQL AAG’s at work for our production databases. There are 3 servers in the AAG, 2 in synchronous replication, one in Async. We have a number of SQL Jobs that need to run, usually just on the primary replica, but occasionally on the other replica’s. We also want to be able to failover the […]
