Press "Enter" to skip to content

Finding SQL Agent Jobs that Start Other Jobs

David Plaut is looking for the root cause:

SQL Server Agent job can start other jobs. Writing jobs this way makes it easy to compartmentalize jobs: start a “child” job only when the “parent” reaches a certain step. Finding these steps can be challenging. There is no field or property in sysjobs or its associated tables to help find child jobs.

Imagine this situation: Job B has started, and you don’t know why. You examine Job B, and it has no schedule. What started Job B?

Read on to learn how you can track down jobs that start other jobs, as well as a recursive lineage of who’s starting whom.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.