• nice post

    there was a similar article a few weeks ago that i extended for the same thing. big difference is i import sysjobs and jobhistory daily for all monitored servers and my report has the reason for the failure in the report.

    later on i plan to extend it with data like average run time to give a heads up if a job suddenly takes longer to run.

    and to get around the annoying int to date conversion i added a date column myself