This series of four posts presents a process to search active SQL Agent jobs. The first three articles describe some utility functions, and the fourth post pulls them all together. The motivation for this series is also spelled out in the fourth post.

1. Find which job steps are reachable
2. Determine if a job is scheduled
3. Determine if a job has executed recently
4. Search only active jobs