SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Maintenance Plans not maintaining
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

WJHamel
Aged Yak Warrior

USA
646 Posts

Posted - 04/08/2013 :  11:32:40  Show Profile  Reply with Quote
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

786 Posts

Posted - 04/08/2013 :  12:04:01  Show Profile  Reply with Quote
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???

Go to Top of Page

WJHamel
Aged Yak Warrior

USA
646 Posts

Posted - 04/08/2013 :  12:55:44  Show Profile  Reply with Quote
Disregard. The related SQL Agent job was disabled in these cases.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000