Enable-Disable Task of subplan in maintenance plan using t-sql

  • Can someone please help me to achieve the subjected task. 
    I need to Enable or Disable one of the tasks of specific subplan Using T-SQL

    Maintenance plan: _SQL_Maint
    SubPlan Name: Subplan1
    Tasks: Task1, Task2 .......... Task9

    I need to enable and disable Task2.

Viewing 0 posts

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