SQL Server troubleshooting – first steps in troubleshooting performance of some TSQL statements (part 3)

Goal

To obtain information about the job names that ran during that interval

My way of achieving it

By querying the history table and by displaying the information in the native format followed by the display using the rows as columns. The last way of displaying the information might have in some cases more meaning that the information that is displayed by default when we check the job history.

The output looks similar to this

JobsInfoPivot

The script can be downloaded from here

Leave a Reply

Your email address will not be published. Required fields are marked *