http://blogs.msdn.com/b/buckwoody/archive/2007/08/07/maintenance-plan-metadata.aspxI was recently asked about which tables are involved in a maintenance plan in SQL Server 2005.The primary tables are: msdb.dbo.sysmaintplan_subplans msdb.dbo.sysmaintplan_log msdb.dbo.sysmaintplan_logdetail msdb.dbo.sysdbmaintplans msdb.dbo.sysdbmaintplan_jobsen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/buckwoody/archive/2007/08/07/maintenance-plan-metadata.aspx#9761135Tue, 16 Jun 2009 15:04:34 GMT91d46819-8472-40ad-a661-2c78acb4018c:9761135 Carpe Datum Maintenance Plan MetaData | work from home<p>PingBack from <a rel="nofollow" target="_new" href="http://workfromhomecareer.info/story.php?id=16684">http://workfromhomecareer.info/story.php?id=16684</a></p><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9761135" width="1" height="1">