InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 08:05:46 GMT20http://www.sqlservercentral.com/Forums/Topic722745-1555-1.aspx[quote][b]Ralf Dietrich (6/21/2009)[/b][hr]Hi Mark,why did you prefer custom maintenance plans over custom SQL scripts? (Yes it is a very interesting solution you showed up! - thx!)I've seen so many bugs in maintenance plans so I prefer not to use them. The most recent bug I've seen was, that it was correctly scheduled (at night) but was executed at a complete other time (mostly during business hours) :-(I could not believe it - but I've it seen 1 month ago! With T-SQL scripts I had never such errors (for more than 10 years now)Ralf[/quote]Ralf:Like you, I have seen many bugs/idiosyncrasies in Maintenance Plans over the years. To this point, I dealt with them.In this particular case, necessity being the mother of invention, I needed to perform all of the standard MP steps, but needed to do it for a certain, fluid subset of 3rd party databases over which I have no control.I used the exact SQL commands that the native plans use for consistency's sake. Of course, you can perform your steps hoever you like, but I wanted to create a good starting point.Hope that answers your question!MJMMon, 29 Jun 2009 14:02:53 GMTMark Marinovichttp://www.sqlservercentral.com/Forums/Topic722745-1555-1.aspxHi Mark,why did you prefer custom maintenance plans over custom SQL scripts? (Yes it is a very interesting solution you showed up! - thx!)I've seen so many bugs in maintenance plans so I prefer not to use them. The most recent bug I've seen was, that it was correctly scheduled (at night) but was executed at a complete other time (mostly during business hours) :-(I could not believe it - but I've it seen 1 month ago! With T-SQL scripts I had never such errors (for more than 10 years now)RalfSun, 21 Jun 2009 14:25:06 GMTRalf Dietrichhttp://www.sqlservercentral.com/Forums/Topic722745-1555-1.aspx***************For everyone's convenience, the SQL scripts and documentation is attached to this post.***************Please let me know if you have any questions.Thank you!MarkTue, 16 Jun 2009 08:42:32 GMTMark Marinovichttp://www.sqlservercentral.com/Forums/Topic722745-1555-1.aspxMark, Very useful and effective article. :-) Can you share the CustomMP_WithDBMail.sql file to my mail id which I mentioned below?jeykumar.net@gmail.comRegards,JeyTue, 09 Jun 2009 06:34:33 GMTJeyakumar-447522http://www.sqlservercentral.com/Forums/Topic722745-1555-1.aspxVery very nice one Mark!It's very usefull if you have large number of db.How can we get the DB_Mail script?Thanks,CMon, 08 Jun 2009 17:04:52 GMTCristi Rhttp://www.sqlservercentral.com/Forums/Topic722745-1555-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Maintenance/66864/">Custom Maintenance Plans - the T-SQL way</A>[/B]Sun, 24 May 2009 11:17:28 GMTMark Marinovic