September 22, 2008 at 6:23 am
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.
September 22, 2008 at 6:33 am
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
September 22, 2008 at 7:03 am
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.
September 22, 2008 at 7:14 am
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]
September 22, 2008 at 7:28 am
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.
September 22, 2008 at 7:58 am
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?
September 22, 2008 at 8:32 am
How can I set this as a shortcut? I notice that it comes up as a seperate application.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply