How to run a SQL Agent job only on the primary Always On node
In a SQL Always On setup, the SQL agent jobs are not synced between the different nodes. This means you need to manually create them on the other nodes. For read-write jobs, you can only run them on…
Read more →
