This discussion is archived
1 Reply Latest reply: Apr 15, 2013 2:08 AM by Veeresh Rayan RSS

Disable the task in DAC

user541642 Newbie
Currently Being Moderated
Hi Gurus,

I have an existing execution plan in DAC.One task is always gives error.

I want to disable the task.

Please let me know how to disable the task in the execution plan of DAC?

~Nichole
  • 1. Re: Disable the task in DAC
    Veeresh Rayan Journeyer
    Currently Being Moderated
    These are the steps.

    1)Go to Tasks tab and heighlight your task or query the task.Click on the Edit tab in the bottom pane.Select Inactive checkbox for that task and save it.
    2)Check if that task has been assigned with any Parent Group(Task Group).If so you might disable Parent task as well by going to task groups and selecting inactive in the bottom pane of the highlighted tasks. Save it.
    3)Assemble your subject area and then build your EP.

    Run full load using the EP which you created.

    To verify that tasks has been removed you go to Execute -->Current Run-->Tasks -->Query that task ans see it is not getting listed.

    However I strongly disagree to disbale any tasks without debuggin it as it may cause data issue in many of the tables.

    Think what is best suited for your environment and situation.

    Please mark correct or helpfull if it helps.

    Regards,
    Veeresh Rayan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points