Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hismightiness
Posting Yak Master
164 Posts |
 Posted - 2008-12-16 : 11:56:40
|
| There is a maintenance plan that was created a long time ago to back-up transaction logs. It is no longer functioning because there is a connection in the list of connections that is not correct. Adding a correct connection and pointing the tasks at it doesn't matter, as the maint plan will bomb parsing the original one.I have tried deleting the maintenance plan to create a new one, but it won't let me.How can I either delete the faulty connection or edit it? The GUI will not let me Edit or Remove it.- - - -- Will -- - - -http://www.willstrohl.com |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2008-12-16 : 13:59:30
|
Outstanding!!! This is what worked for me (from that link):quote:
Originally posted by janetb
Found this and it worked like a charm - hope it helps someone else.1. Select the ID with the select statementselect * from sysmaintplan_plans2. Replace with the selected ID and run the delete statementsdelete from sysmaintplan_log where plan_id = ''delete from sysmaintplan_subplans where plan_id = ''delete from sysmaintplan_plans where id = ''3. Delete the SQL Server Jobs with the Management Studio
- - - -- Will -- - - -http://www.willstrohl.com |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-16 : 18:16:28
|
| Good!!! |
|
|
|
|
|
|
Delete/Edit Maintenance Plan Connection