Kenneth Fisher only looks at the best SQL Agent jobs:
But sometimes what you want is an overall history. Maybe you want to see your longest running jobs? Or the most frequent jobs? Or jobs that are failing? There is a great pre-built report just for that.
Now, be warned. The report and the history view both pull from the system views and they only hold so much history. You need to make s
With that warning stated, this is a good report if you just want to get some idea of what’s happening on your server.