· 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..