QMC Triggers and Dependencies

[megabyte23]

Hello,

I have two tasks I want to schedule into QMC. The Task #1 generates a QVD and the Task #2 consumes the QVD. I see that I can create a Task Dependency on Task #2 for the completion of Task #1 and then I can increase "Task Execution Options" so that it will keep retrying.

It makes more sense to me that I could simply run Task #1 and when it's complete call Task #2. Is there any way to do this or do I need to go with the solution I outlined?

Thank You for your time.

[johnca]

What do you mean by "I can increase "Task Execution Options" so that it will keep retrying"? A dependent task only runs once unless you make changes to the "Task Execution Options" which will allow a dependent task to run again if it failed. You may set the "Number of tries" to as many as you think it may take to pass. The :Timeout in minutes" must be set to a number of minutes higher then the combined time for all possible tries. So, if you set the "Number of tries" to 5 and it typically takes 10 minutes to run you must set the "Timeout in minutes" to 50, minimum.

You would set it up the basic dependent task the same either way. You do not need to do anything other than set the second task to run after the first. If you need it to run more often have the first task set the pace by setting that to run whenever you need.

HTH,

John

[megabyte23]

Thanks Johncaqc. I think we are on the same page in understanding. If I set "Number of tries" for Task #2 to 5 and Task #1 still does not complete in that time, Task #2 will cease the attempts and never run which is not our preferred outcome. We have a number of dependencies built into our data warehouse that can impact the time jobs will take, so this is at the end of that chain and I don't want to have to specify a time limit on it.

I think I found the answer. It looks like a Trigger will force Task #2 to begin when Task #1 completes. That is what we're looking for.

[johnca]

No, that is not what happens. If task 1 doesn't pass task 2 will never start.

So, yes, just have task 2 trigger off a successful task 1.

[Chip_Matejowsky · Accepted solution]

Hi @megabyte23 

---

@megabyte23 wrote:

It makes more sense to me that I could simply run Task #1 and when it's complete call Task #2. Is there any way to do this or do I need to go with the solution I outlined?

---

Yes, you can trigger a task from the completion of a previous task. Have a look at the QlikView online Help for Task Triggers

On Event from Another Task

When the On Event from Another Task trigger type was chosen, the trigger can be configured to start the current task on the event from another task. The following configuration options are available:

Start on

Choose a trigger event, by clicking on one of the following options in the drop-down list:

• Successful, meaning that the execution of the task was successful
• Failed, meaning that the execution of the task failed

Completion of

Choose a trigger task, by clicking on one of the options in the drop-down list.

[Brett_Bleess]

Meg, did John or Chip's comments get you what you needed?  The On Successful Completion trigger should have been the correct solution based upon what you explained.  If they helped, be sure to use the Accept as Solution button on their posts to give them credit and let others know that worked.  If you are still struggling with things, leave us an update.

Regards,
Brett

[megabyte23]

Thanks for the prompt. I got it to work last night. I marked the solution. (On successful completion trigger)