THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

Vote on Connect: Graphical UI for SQL Server Agent

When you only have a few SQL Server Agent jobs, it’s easy to keep track of and make sense of them. I’m using a graphical free tool called SQLjobvis (screen capture below), available at http://www.sqlsoft.co.uk/sqljobvis.php. It provides a visual view of completed SQL Server Agent job steps. See the screen capture below.

Wouldn’t it be great if Microsoft offered a graphical UI for SQL Server Agent? I’d like Microsoft to provide viewing and graphical editing of SQL Agent job schedules. Please vote on this Connect item:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=524854

SQLjobvis_capture

Published Wednesday, January 13, 2010 10:36 PM by John Paul Cook

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Rasmus said:

Hi

I have just tried SQLJobVis and it seems quite cool. Are there any plans for developing an export tool so it can be used for basic documentation.

Kind regards

Rasmus

January 18, 2010 7:10 AM
 

Rasmus said:

Furthermore, I would be nice if one could select several servers at the same time e.g. if you have a development server and a production server which extracts data from the same source in a data warehouse environment.

January 18, 2010 7:16 AM
 

Justin said:

I'd rather MS focused on improving SQL Agent functionality instead of a GUI.  SQLSentry http://www.sqlsentry.net/ is an excellent tool for viewing and managing SQL Agent jobs. There are also a multitude of publicly available user stored procedures and scripts developed by very smart DBAs that interrogate the appropriate tables in msdb to present readable and thorough information about SQL Agent jobs.

January 18, 2010 1:54 PM
 

Will said:

Hi - I'll add multiple server connectivity and exporting of the job run times into a version to be released in the very near future.  If you've any suggestions as to how you'd like these implemented, or any other requests, just let me know.

Regards,

Will Alber (SQLsoft).

January 30, 2010 10:19 AM
 

Will said:

I've just released SQLjobvis 3.0 Beta on the SQLsoft website - the direct link is http://www.sqlsoft.co.uk/binaries/SQLjobvis3beta.zip.  It's now an MDI application, so you can easily connect to multiple servers, and there's now the ability to export the current view to either .csv or tab-separated .txt files.

If you've any feedback just drop me a line at support@sqlsoft.co.uk

Best Wishes,

Will Alber (SQLsoft).

February 11, 2010 2:36 AM
 

Steve Jones said:

I think this is an excellent tool: it's free, does not install any components on the servers you're looking at, and provides that all important time line for your SQL Agent jobs so you can check for contention.

Nice work!

October 21, 2011 7:35 AM

Leave a Comment

(required) 
(required) 
Submit

About John Paul Cook

John Paul Cook is a Technology Solutions Professional for Microsoft's data platform and works out of Microsoft's Houston office. Prior to joining Microsoft, he was a Microsoft SQL Server MVP. He is experienced in Microsoft SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a Registered Nurse who graduated from Vanderbilt University with a Master of Science in Nursing Informatics and is an active member of the Sigma Theta Tau nursing honor society. He volunteers as a nurse at safety net clinics. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement