What happened to all the extra columns in Sql Agent - Jobs???!!!

  • I am in the process of converting my production server (2000) to my new production server (2005). I am now in the process of converting the 50+ nightly jobs we have running on the 2000 server. I have setup a job on the 2005 server, but I don't see any of the useful detail that was present in the job list on my 2000 server.

    I admit, that I am new to 2005. I have looked through all of the menus and can't find any way to show the same columns that were shown in the 2000. The columns I am talking about are Last Run Date, Next Run Date, Enabled, and Status. Also I would like to see the icon that shows if the job failed on not.

    If I am going to have to right click and view history on each job to see if they have succeded overnight, my job is going to get real tedious real fast. Please tell me that they haven't handicapped the abilities of the Sql Agent - Jobs.

    Thanks in advance for any responses to this post.


    Live to Throw
    Throw to Live
    Will Summers

  • Hi,

    I know you said you'd looked in all the menus, but if you click on Filter in Job Activity Monitor you can select which columns you want. Don't know if you've already tried that.

    Cath

  • If I click on Filter it only gives me an option to filter the results that I am seeing. I don't see any options to show/hide columns.


    Live to Throw
    Throw to Live
    Will Summers

  • Will Summers (9/22/2008)


    The columns I am talking about are Last Run Date, Next Run Date, Enabled, and Status. Also I would like to see the icon that shows if the job failed on not.

    I have all of those in my Job Activity Monitor, and I cannot remember ever modifying it. Are you sure that you are looking at the Job Activity Monitor and not the Object Explorer Details tab of the Jobs folder?

    The Job Activity Monitor is in the Explorer pane, under the "SQL Server Agent" folder, just after the "Jobs" folder. Double-click on the Icon and a separate Monitor window will come up

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • That was what I was looking for! Thanks.

    why, oh why did they split it up into jobs and job activity monitor? What functionality are they giving me doing that?

    Maybe I'm just not seeing the big picture, but this seems like it wasn't developed by someone who is actually using the product to maintain databases in production.


    Live to Throw
    Throw to Live
    Will Summers

  • That was kind of my thought when I started using it. And then I figured out that I could get everything I used to have through the Job Activity manager (add job/start/stop/check status), while still having access to the other areas available.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • How can I set this as a shortcut? I notice that it comes up as a seperate application.


    Live to Throw
    Throw to Live
    Will Summers

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply