Subscribe to this blog
Briefcase
Print
If you have experience with the SQL Server Agent you quickly realize the difficulty in managing job schedules. On a busy server with many SQL jobs scheduled to run throughout the day at various times finding clashing job schedules and long running jobs is hard to do using the native SQL Server tools.
To address this issue I’ve been looking for a simple way to visualize the SQL Agent job schedule information and I was just about to write my own tool before finding a very nice product called SQLJobVis from SQLSoft. Using SQLJobVis I was able to quickly see jobs that were long running and jobs with overleaping schedules:
SQLJobVis is a great example of how data visualization in the right way makes finding information much easier. At this point, the utility is freely available from SQLSoft and they are just looking feedback and feature requests. So, give SQLJobVis a try and be sure to let them know if you find the tool useful.
Posted by Robert Davis on 16 May 2010
Looks like an interesting tool.
I've downloaded to try out. From an initial look, it looks like it has potential but is lacking in features such as the ability to graph mutliple servers together and filter the output by specific job types. Also the only available export types are csv or tab delimited text file. I would like to be able to export the graph or send the graph via HTML email. It would be especially nice if I could schedule it to email a report on a recurring basis.
After I try it out a little more, I'll send some feedback to the company.
Posted by cmille19 on 17 May 2010
Agreed -- it could do more, but its still light years ahead of the reports for SQL Agent that come with SSMS. What would be really cool is to create an SSRS report that can be used in SSMS or scheduled on an SSRS server. That was the path I was originally going down until I noticed this tool.