depicus

Remove MSSQL Maintenance Plans after renaming a server

Author: The Man

1. Get the id of the jobs you want to remove, open a query and check you are in MSDB then

SELECT * FROM sysmaintplan_plans

2. Replace with the selected ID and run the DELETE statements

DELETE FROM sysmaintplan_log WHERE plan_id = ’351EDD9C-7154-46EA-B817-A1B036F43C81′
DELETE FROM sysmaintplan_subplans WHERE plan_id = ’351EDD9C-7154-46EA-B817-A1B036F43C81′
DELETE FROM sysmaintplan_plans WHERE id = ’351EDD9C-7154-46EA-B817-A1B036F43C81′

3. Delete the SQL Server Jobs within the Management Studio

All done.

This entry was posted on Thursday, October 6th, 2011 at 10:30 am and is filed under Interweb. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.