Vote on Connect: Graphical UI for SQL Server Agent

PingBack from http://topsy.com/tb/bit.ly/6hxwM0

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

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.

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.

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).

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).

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!