Drawback of Miantenance Plans compared to SP's

Maintenance plans:

·         Not advisable for complex tasks.

·         If mixed recovery models on one server it’s much easier to use t-sql scripts than maintenance plans.

·         Difficult to us in database mirroring. As MP’s

·         Consistency between sql versions.

·         Time window logic is much easier in t-sql scripts than MP’s. Like after full bckup if enough time is there then if planning to perform defragmentation and so on..