AppInsight for SQL Job Report in SWQL Custom Query Resource

Version 2

    SWQL for custom resource, fields include job name, application and the node it's on, last run in local time, duration, and status with icon. My example below is poor since I have no failed jobs and the blank rows are from jobs that never ran.

    • Remove the comment lines (--) from in front of the where clause to only show the jobs which did not succeed.
    • Remove the application section to be able to make more narrow and embed on smaller page.

     

    Screen Shot 2015-03-16 at 11.11.27 AM.png