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 |
|
tcbrown24
Starting Member
8 Posts |
 Posted - 2007-06-12 : 10:29:20
|
| I am monitoring maintenance plans for failure and duration. Finding jobs that were deleted still showing up. They exist in the msdb.sysjobs, msdb.sysjobschedules, msdb.sysjobservers, and msdb.sysjobsteps. But not in the msdb.sysdbmaintplan_jobs, msdb.sysdbmaintplan_history, msdb.sysdbmaintplan_databases.I am seeing this problem in both SQL Server 2000 and 2005 (fresh install). Why are some plans cleaned up when deleted and some not, but more to the point; what is the best (safest) way to clean up these records? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-12 : 11:54:24
|
| Never had that on my servers. Do you still see them under jobs? |
 |
|
|
tcbrown24
Starting Member
8 Posts |
Posted - 2007-06-12 : 12:15:59
|
| No I don't see them under jobs, thought they were deleted fine until I started pulling job information into a repository to monitor what is happening with all the jobs on all the servers. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-12 : 12:27:07
|
| In this case, I'll create couple of testing plans then set profiler to trace plan deleting to see what happens. |
|
|
|
tcbrown24
Starting Member
8 Posts |
Posted - 2007-06-12 : 12:39:17
|
| I'll give it a go. Most of the jobs seem to have deleted fine, recently deleted all plans and started over from scratch, there were just a handfull of rogues. Therefore may not be able to recreate the problem. |
|
|
|
tcbrown24
Starting Member
8 Posts |
Posted - 2007-06-12 : 14:21:08
|
| Don't seem to be able to recreate the problem on other plans. Will look at the sql for the delete and see if I can delete what didn't get deleted the first time. after I make sure I have a good backup of the msdb database. |
|
|
|
|
|
|
maintenance plan ghosts