Don't have Telegram yet? Try it now!
http://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