We run Analysis Services on the same server as an asynchronous copy of SQL (mainly for licensing reasons). We have been having problems when processing the cube that it drops the TCP connection to SQL. It was suggested that we use Named Pipes instead of TCP connections. We don’t want to turn off TCP completely, so […]
As part of starting writing blog posts, I wanted to force myself to stop and reflect on what I have learnt to do. This is something that I’ve always been bad at doing and I think that’s true for many in the IT world. As a DBA/Programmer I tend to solve a problem and then […]
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 […]
