Please Microsoft make my life easier - Simon Sabin UK SQL Consultant's Blog

Please Microsoft make my life easier

I do get frustrated sometimes by the very poor user experience you get with management studio.

My most recent annoyance comes when looking at job histories, if you want to look at the details of the step that failed you have to go and find the job, open it, find the job step and open it. If you've got loads of jobs this can take some time. Especially with the popup window behaviour of management studio.

This is a connect item that would allow us to double click on an item in the job history and open the job properties directly. I reckon for a moderately busy DBA this would save days of effort per year.

http://connect.microsoft.com/SQLServer/feedback/details/531889/allow-access-to-job-details-from-the-log-file-viewer-to-improve-manageability

If you think this would be a good suggestion then please vote for it.


Published 08 February 2010 10:28 by simonsabin

Comments

08 February 2010 10:41 by Twitted by chuckboycejr

# Twitted by chuckboycejr

Pingback from  Twitted by chuckboycejr

# Twitter Trackbacks for Please Microsoft make my life easier - Simon Sabin UK SQL Consultant's Blog [sqlblogcasts.com] on Topsy.com

Pingback from  Twitter Trackbacks for                 Please Microsoft make my life easier - Simon Sabin UK SQL Consultant's Blog         [sqlblogcasts.com]        on Topsy.com

08 February 2010 12:04 by jamiet

# re: Please Microsoft make my life easier

I had a similar epiphany the other day - although it wasn't regarding SQL Server.

How much more useful would it be if you could right-click on a service in the services panel and say "Show me all the event log events for this service", instead of having to go thru eventvwr and search for them manually.

-Jamie

08 February 2010 13:46 by SqlServerKudos

# Please Microsoft make my life easier

Kudos for a great Sql Server article - Trackback from SqlServerKudos

08 February 2010 21:14 by Ennor

# re: Please Microsoft make my life easier

Right mouse button on the job (either in the tree or on the Details pane), then "View History". At least it works in SSMS 2005 SP3.

The only problem is that sometimes this log does not hold any useful information. In case of SSIS package or maintenance plan task, for example, there may be nothing useful here - you have to go to the SSIS packages history.

SSMS does not stands much for a "management", sure.

08 February 2010 22:51 by simonsabin

# re: Please Microsoft make my life easier

Thats fine going from a job to the history. Try going the other way. You've found something in the log and want to see the job, its a pain.

As you say its worse with maintenance plans and ssis jobs.

18 February 2010 22:57 by Life is Easier

# Life is Easier

Pingback from  Life is Easier