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.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  Another stuck Maint Plan

Author  Topic  jgurley Starting Member 1 Post Posted - 2010-02-19 : 13:24:45 I have an SQL2008(Windows 2003SP2 x64) server with another one of those invisible, yet still executing maintenance plans. The plan was established ten years ago under SQL2000 before we upgraded last fall. This plan showed up under the "Legacy" tree in the 2008 console. I deleted it (since I have all new plans involving more databases), but the plan keeps running (and no longer appears in the Legacy tree). Unlike other posts I've read on this forum, there are no files in the .../TEMP directory, and as posted on some other forum, I don't have Integration Services, so that path doesn't work. I'm not a developer, so I'll need more detailed guidance than "select these tables from MSDB..."