How to Delete Maintenance Plan in SQL 2005

Step 1:
DELETE FROM MSDB..SYSMAINTPLAN_PLANS

Step 2:
DELETE FROM SYSMAINTPLAN_LOG

Step 3:
DELETE FROM SYSMAINTPLAN_SUBPLANS

Step 4:
DELETE FROM SYSMAINTPLAN_PLANS

Update me when site is updated

Leave a Reply

You must be logged in to post a comment.