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 |
|
rhavenn
Starting Member
14 Posts |
 Posted - 2009-10-29 : 15:52:23
|
| We've got a server that had some issues prior to my time and was some how rebuilt / restored from a different server via a vmimage.The management GUI shows two Maintenance Plans, but both haven't been running for many months. They're scheduled to run weekly.server: windows 2003 and sql2008 instance.The problem: I can't delete the maintenance jobs.sp_help_maintenance_plan shows no MP jobs and right clicking and doing "delete" just pops an error.The errors in the history log for the jobs show errors relating to DTSER_FAILURE.Any ideas? |
|
|
rhavenn
Starting Member
14 Posts |
Posted - 2009-10-29 : 17:06:39
|
| This link solved the issue:http://www.sqlservercentral.com/Forums/Topic458331-149-1.aspx |
 |
|
|
|
|
|
stuck maintenance plans (solved)