• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 747
  • Last Modified:

Any way to change sequence of columns in View History/Log File Viewer in SQL Server 2008?

We are testing SQL Server 2008 to move from 2000.  When I review the history of SQL Agent jobs in 2008, the view shows many more fields than in 2000.  The field I review the most is Duration.  In 2000, you could see it without scrolling.  In 2008, you have to scroll a lot to get to this field.  I tried to modify the view and I was able to drag it farther to the left, but my changes weren't saved.

Can the history view be modified so that I can see the fields in the sequence that I want?   I also want to move server name/instance name to the far right, along with a few other fields.

Thanks,
Alexis
0
alexisbr
Asked:
alexisbr
  • 4
  • 2
3 Solutions
 
Kevin CrossChief Technology OfficerCommented:
The columns are dragable, so you can simply move it over to the left.
0
 
santhimurthydCommented:
Check this link
http://msdn.microsoft.com/en-us/library/cc879320.aspx


Note from the link : To rearrange the order of the columns, click the column heading and drag it to another location in the heading ribbon.
0
 
Kevin CrossChief Technology OfficerCommented:
I have not found a way to make the change permanent, but then again I have not looked very hard. The columns are also resizable; therefore, I typically will squeeze ones I don't need together so I can see what I need on screen.
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
alexisbrAuthor Commented:
Thanks for your replies.  As I said in my question, I have moved the columns around and I also have squeezed the columns together that I don't need.  This works like any other datasheet/grid I have worked with.  However, I don't want to have to set the columns each and every time I review job history.  In SQL Server 2000, only a few columns were displayed, and one of them was Duration so I didn't have this problem before.  I review Job History all the time and having to scroll over all the time to see the duration will be a huge pain.  I'm surprised there's not a setting to allow you to select the columns you want to see, like you can in Outlook.
0
 
Kevin CrossChief Technology OfficerCommented:
You could always write a custom report.
0
 
Kevin CrossChief Technology OfficerCommented:
0
 
alexisbrAuthor Commented:
Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now