Saturday, June 30, 2012

Jobs Execution Status Report

I came across new two new reports in SSMS. (This report is available in SQL Server 2008 R2 and onwards). Those are coming under SQL Server Agent as shown below.

 

image

This report gave me this.

image

You will see in the key, there are two of # Successful Executions in green and in purple color!. I have never seen a chart key like this. Have you?

Difference between the purple and green is, Green “# Successful execution” for the successfully completed jobs while the purple one is for the canceled jobs. Should it be nice, if we have a different text for this, rather than having the same name for both.

No comments:

Post a Comment