• Jeff Moden (12/17/2014)


    I built one of those that I receive from each server every morning (I've only got a half dozen that are "production"). It also tells when the next time is that the job will run and the last time the job was modified. It highlights "one time" jobs in Orange and highlights disabled jobs and disabled schedules in Yellow. Of course, any failures or retries are highlighted in Red. I'm considering writing an article on the subject.

    But, it's not a web page. It certainly could be because I built it all as HTML from T-SQL but it isn't currently a web page.

    Would that do?

    Sounds good. I have simple t-sql to check instances we have for job status at the step level and would be interested in different solutions.