This is the final optional step in replicating jobs between SQL instances in an AlwaysOn Availability Group. We use SQL Reporting Services to generate reports for the business. Some of the reports are scheduled to run by business users. When you schedule a job in SSRS it creates a SQL Agent Job. We want to […]
This is part 6 of the Replicating Jobs series. In the previous steps I’ve covered how to setup for replication, how to copy categories, schedules and jobs, and now finally we need to link Jobs to Schedules.
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 […]
