sysdbmaintplan_history table

Last Post 03 Aug 2006 08:03 AM by talltop. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ogruizr
New Member
New Member

--
13 Jul 2006 12:07 PM
Hi all:

We have a web site (intranet) to monitoring our SQL Servers. In that web site we can see server status, space of log and data files, jobs... To monitoring Maintenance plans we use sysdbmaintplan_history table. That table is in msdb. We are installing SQL Server 2005 and we are having problems with maintenance plans. In SQL Server 2005 sysdbmaintplan_history table is empty. I was reading and I found that sysdbmaintplan_history table in SQL Server 2005 is for upgrade. What table in SQL Server 2005 is replacing sysdbmaintplan_history table? or is there an stored procedure to check maintenance plans?
talltop
New Member
New Member

--
03 Aug 2006 08:03 AM
Try msdb..sysmaintplan_logdetail
You are not authorized to post a reply.

Acceptable Use Policy