Last week I had interesting (or I can say weird ? ) case of Maintenance Plan. One of the server that we monitor has reported job failure – this was a part of maintenance plan. Looking at the job history and log file I came to know that this job was failing because of some database which wasn’t available – this database was dropped few days back, and, the maintenance plan has it’s reference stored somewhere. I have search around system tables etc. but nothing unusual or nothing helpful was available that indicates the source of this database.
Finally, I have edited the maintenance plan which resolved this case, here is what I did:
Finally, I have edited the maintenance plan which resolved this case, here is what I did:
- Alter the maintenance plan "some maintenance plan"
- note down the databases name
- altered it and selected all the system databases
- saved the maintenance plan changes and exit
- re-open the maintenance plan
- re-selected those databases (from step 2)
- saved the maintenance plan changes and exit
- re-invoked the job
- and, the job completed successfully
And, the mystery persist, can you guys suggest me if I miss something to refer/research ?
-- Hemantgiri S. Goswami (http://www.sql-server-citation.com )
