A customer wanted a report they could email to their boss about jobs, something that showed failures. This isn’t hard to get in Redgate Monitor, though it is manual (for now). Here’s how to do this.
This is part of a series of posts on Redgate Monitor. Click to see the other posts.
The Estate View of Jobs
Under the Estate menu item, there is an entry for jobs.
Click this and you get to the estate view of jobs. Here I see an overview, and I can click the scale in the upper right for day/week/month.
Below this I see the failed and successful job details, though only for the most recent execution. Otherwise this is a ton of data. Good to note that the 10 jobs that failed must have succeeded on a subsequent run.
There is a button to see the details. Click Export:
This downloads an Excel sheet of my jobs. There is a summary tab of the status with some details by day.
In the job details, I see the last run status for jobs. In this case, I don’t have any failed jobs (last run). However, I downloaded this earlier in the day, when I did have a job that failed in its more recent execution. Here’s what I see in the details if I scroll across. Look at the top line, which is the failure.
I can see the reason the job failed and the date/time.
If I were grabbing this every day, I’d have a nice report of how things are going. I would like to see a more detailed version of a report, and if you want it, please email sales@red-gate.com and request it.
Summary
Getting reports to share with others is important. As much as I’d just like to get people to look at the tool, I do understand having periodic reports. I used to self-generate these and store them off in a secure place. These were invaluable for auditors and kept them from asking me lots of questions.
You could do this as well, and Redgate Monitor makes it easy to get this info. Look for enhancements in this area in the future that might help you with estate level reports for your management (or auditors).
Redgate Monitor is a world class monitoring solution for your database estate. Download a trial today and see how it can help you manage your estate more efficiently.