Gantt Chart of SQL Jobs

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:

http://www.sqlsoft.co.uk/sqljobvis.php

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s