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 |
WJHamel
Aged Yak Warrior
651 Posts |
Posted - 2013-04-08 : 11:32:40
|
So we have maintenance plans set up on our servers which are supposed ot delete saved backup jobs older than four weeks. The MP's exist and are enabled, but are not doing anything. I did notice that in the settings for the MP, under Misc, the option for DatabaseSelectionType is set to "None". ought this not be set to "All" or "User" to get rid of things??? |
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2013-04-08 : 12:04:01
|
Are you talking about a maintenance cleanup task inside a MP?I did not find settings/misc/databaseselectiontype inside my 2008r2 ssms. quote: Originally posted by WJHamel So we have maintenance plans set up on our servers which are supposed ot delete saved backup jobs older than four weeks. The MP's exist and are enabled, but are not doing anything. I did notice that in the settings for the MP, under Misc, the option for DatabaseSelectionType is set to "None". ought this not be set to "All" or "User" to get rid of things???
|
|
|
WJHamel
Aged Yak Warrior
651 Posts |
Posted - 2013-04-08 : 12:55:44
|
Disregard. The related SQL Agent job was disabled in these cases. |
|
|
|
|
|