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 |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2009-09-09 : 14:50:02
|
| FolksI have a unique problem.I have SQL 2005 VM. with 2 user databases.there are three maintenance plans1. Full nightly backup2. Re-indexing3. hourly transaction logs backup.I had only opened one job to disable its schedule for that night. Reopened it next day and re-enabled the schedule. After that we did not receive any emails since then.This morning I found something happened and the email notification steps in each of these got deleted. I know I didn't do it, nor did any of my colleagues.Unlike in the DTS package designer, we cannot see the different versions of this maint. plans. Is there any table/DMV where I can look into, to find the history of changes to the maintenance plan.Anybody have any slightest clue?RegardsRegardsParesh MotiwalaBoston, USA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Deleted steps from a Maintenance Plan