March 10, 2011 at 2:42 pm
In SQL 2000, I used a query like the following to check for failure of maintenance plans each night:
select count(*) as errorCount from sysdbmaintplan_history
where (succeeded <> 1)
Where would I find the same information in SQL 2008?
Thanks,
Caroline Hecht
March 10, 2011 at 3:58 pm
This might be what you want (sysdbmaintplan_history )
http://technet.microsoft.com/en-us/library/ms173549(SQL.90).aspx
March 11, 2011 at 11:45 am
That page gives info about the sysdbmaintplan_history table, but states that it is no longer used in SQL 2008. My question is where to look for the info now that it's not stored there.
March 11, 2011 at 1:47 pm
Caroline Hecht (3/11/2011)
That page gives info about the sysdbmaintplan_history table, but states that it is no longer used in SQL 2008. My question is where to look for the info now that it's not stored there.
Sorry but this is all the additional info I could locate:
SQL Server 2008 R2
http://msdn.microsoft.com/en-us/library/ms190275.aspx
SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms190275(v=SQL.100).aspx
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply