View Full Sql Output

by Dec 23, 2013

I am creating an MSFT SQL basic check that executes a stored procedure to monitor job status.  It takes the name of the job and spits out a one liner that can be grep’d for Success, Failure or In Progress, good enough.

 

Couple of questions:

 

Is if there is a way to display the raw output somewhere in addition to the “calculated result” of the regex string match?  It would be great to see this as 1) in the alert emails I could show my DBA’s the last time that the job kicked off and 2) Maybe that info could be displayed in the services section and thus available on the dashboard.