Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Chad Miller

Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. Chad is the Project Coordinator/Developer of the Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is a frequent speaker at users groups, SQL Saturdays and Code Camps.

SQL Agent Visual Job Schedule Viewer

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

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.

Comments

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.

Leave a Comment

Please register or log in to leave a comment.