Deleting maintenance plan history

[tonykblen]

Hi,

I would like to know whether there is a way of bulk deleting maintenance plan history from SQL Server 2000. Can I use a delete SQL statement in order to do this without having any adverse effects elsewhere?

Many thanks,

Tony Kennedy.

Tony Kennedy BSc. B.I.S.,
MCSA Cand.

A good start is half the work.
Every start is difficult .
-Two Gaelic proverbs

 

[JayKusch]

You can use the table named sysdbmaintplan_history in the MSDB database. Open the system table up and you can then delete the plan histories based on plan name.

Thanks

J. Kusch