Recently, the need to map out SQL Jobs and their times has become more important to me. I needed a listing of SQL Jobs the scheduled times, and their duration, with the status. While our in house management tool provided the information I wanted an easier and more friendly tool to view these through, so I planned on writing my own Report from Reporting Services, but found an amazing tool that did it for me.
SQL Soft’s SQLjobvis is a free job visualiation viewer and looks great. This provided me with exactly what I was looking for. In the future, I plan on doing one which calculates an average, and displays an entire month, overlapped on one day, to get an idea of average use, but that will be a future post.
The SQLjobvis can be found here: