https://www.techmixing.com/2015/01/sql-script-to-find-list-of-all-jobs.html
SQL Script to find the list of all the jobs failed yesterday