pcd_au - Wednesday, November 14, 2018 3:35 PM
Hi pcd,
Thank you for the comment!
Yes you are right, once could go about selecting jobs based on category too, that could definitely work.
Simply replace the jobs query with one from msdb..sysjobs
As for ensuring jobs are on all servers and the jobs are the same...
First one would need to set up a linked server for each replica.
Normally, setting up availability groups or database mirroring don't do that for you. So that's one extra step you'd have to do.
Next, you could query from msdb..sysjobs and msdb..sysjobsteps on each linked server and compare their contents.
It's kind of beyond the scope of this blog post, I think. But it shouldn't be too hard to do.