Add Control Flow Tasks to Maintenance Plan Toolbox

  • When I open up a Maintenance Plan in Management Studio it only shows Maintenance Plan Tasks. Is it possible to add Control Flow Tasks to the Toolbox or at least Execute Process task or Script task, without going into BIDS?

  • Not sure, I don't think so..

  • In the Mailtenance plan, if you right-click Maintenance Plan Tasks in the Toolbox, you will have an option in the context menu called Choose Tasks. You can add more tasks such as Execute Transact SQL Script, which I guess is what you are tryign to achieve.

    Regards,

    Chris Fitzgerald 😀

  • You can add more tasks such as Execute Transact SQL Script, which I guess is what you are tryign to achieve.

    He wanted "Execute Process task or Script task" right.?

  • San, You are correct I am wanting to ad "non-maintenance plan tasks" from the Control Flow Items toolbox.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply