Custom Maintenance Plans

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Mark Marinovic » Custom Maintenance Plans - the T-SQL way

Custom Maintenance Plans - the T-SQL way

Rate Topic

Display Mode

Topic Options

Author

Message

Mark Marinovic

Posted Sunday, May 24, 2009 11:17 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, June 10, 2013 9:00 AM
Points: 223, Visits: 285

Comments posted to this topic are about the item Custom Maintenance Plans - the T-SQL way

Post #722745

Cristi R

Posted Monday, June 08, 2009 5:04 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 31, 2010 4:47 AM
Points: 1, Visits: 5

Very very nice one Mark!
It's very usefull if you have large number of db.
How can we get the DB_Mail script?

Thanks,
C

Post #731031

Jeyakumar-447522

Posted Tuesday, June 09, 2009 6:34 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, August 16, 2012 2:29 AM
Points: 35, Visits: 124

Mark,

Very useful and effective article. Smile

Can you share the CustomMP_WithDBMail.sql file to my mail id which I mentioned below?

jeykumar.net@gmail.com

Regards,
Jey

Post #731382

Mark Marinovic

Posted Tuesday, June 16, 2009 8:42 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, June 10, 2013 9:00 AM
Points: 223, Visits: 285

***************

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!

Mark

Post Attachments

Custom Maintenance Plans.zip (31 views, 27.61 KB)

Post #735718

Ralf Dietrich

Posted Sunday, June 21, 2009 2:25 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, December 21, 2011 3:09 PM
Points: 390, Visits: 86

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

Post #739111

Mark Marinovic

Posted Monday, June 29, 2009 2:02 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, June 10, 2013 9:00 AM
Points: 223, Visits: 285

Ralf Dietrich (6/21/2009)

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!

MJM

Post #743935

« Prev Topic | Next Topic »

Permissions