Contents tagged with SQL Jobs

  • Script to find orphaned/unreachable job steps within your SQL jobs

    SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created by allowing great flexibility with the scheduling, execution, flow actions and notifications. Invariably, when jobs are setup, they just run and run without many problems, but the other day I was called in to look at a problem where a SQL job seemingly wasn’t doing everything that it should be doing, namely the job steps.

    After a bit of digging around, I discovered that the flow …