February 16, 2009 at 11:46 am
In SQL 2000, I am able to use SQL Enterprise Manager to view all my SQL 2000 servers and easily verify that my backup/maintenance jobs had run successfully by expanding 'SQL Server Agent' under 'Management' and looking at the 'Last Run Status' for each server. When I try to do the same thing in SMSS for my remote SQL 2005 servers, neither the 'Maintenance Plans' under 'Management' or the 'SQL Server Agent' are viewable, although most of the rest of the database objects and their sub-objects are viewable. There must be a built-in way to do this, but I have searched BOL and repeatedly attempted to find an answer on Google. I must be putting in the wrong keywords or something.
February 25, 2009 at 11:40 am
Is there really no answer to this question, or is there another reason I'm not getting any replies to this?
March 3, 2009 at 11:17 am
For maintenance plans, goto Management & Right click on Maintenance Plans, then click on View History
For jobs, goto SQL Server agent, right click on Jobs folder and click view history.
--
Or query the msdb table and pull the results together in 1 table somewhere for all yours servers and view it there.
Do something like this:
http://www.sql-server-performance.com/articles/dba/centralized_sql_server_monitoring_p1.aspx
And grab other data with it like last backup time
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1178991,00.html
March 5, 2009 at 1:48 pm
Thank you. I'll work through these in the next few days.
Paul
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply