topic Re: Tasks with multiple levels running into eachother in QlikView

Tasks with multiple levels running into eachother

joshabbott — Fri, 26 Aug 2016 13:47:15 GMT

Hello!

I've set up some tasks in the QMC with triggers 'on successful completion of the previous task'. For example:

Task 1 - Trigger - Run every hour

Task 2 - Trigger - Run on completion of Task 1

Task 3 - Trigger - Run on completion of Task 2

Task 1 and 2 create qvd files that task 3 reads. The problem I'm running into is, sometimes, task 3 isn't finished running when task 1 kicks back up. How do I make it so Task 1 skips its hourly reload if Task 2 or Task 3 is still running? Thank you for any help!

Re: Tasks with multiple levels running into eachother

MindaugasBacius — Fri, 26 Aug 2016 13:53:17 GMT

Task 1 - Trigger - Run every hour and a half.

Re: Tasks with multiple levels running into eachother

joshabbott — Fri, 26 Aug 2016 14:13:53 GMT

Task 2 and 3 are inconsistent thought, it might need to wait 2 hours, and if it only needs to wait 1 hour, then it should run every hour.

Re: Tasks with multiple levels running into eachother

HirisH_V7 — Fri, 26 Aug 2016 14:33:39 GMT

Hi,

Can you please specify the exact time taking for each and every tasks,Mean while In that Does Task1 and Task 2 both create QVD's or there are dashboards.

may be this way, If the time taking for each & every Task is not constant means. You can go with a individual QVW with both QVD generation and loading the data in the same dashboard itself which is promptly required to update regularly.

HTH,

Hirish

Re: Tasks with multiple levels running into eachother

ramchalla — Fri, 26 Aug 2016 14:34:24 GMT

First check the time it takes all the tasks to complete. Then you will come to know how to schedule the Task1.

Re: Tasks with multiple levels running into eachother

maxgro — Fri, 26 Aug 2016 14:46:00 GMT

I think you should add something (it could be a file or a flag in a file) to indicate the task 2 or 3 is running.

At the start of task 2 you set the flag (RUN) and at the end of 3 you reset (NOTRUN).

Task 1 should read in loop the flag (look at sleep function) and wait until there is the NOTRUN.

Another option is to abort task 1 when there is a RUN (this is if you want to wait until next hourly reload; you can abort with a load from a not existing qvd).

You also need a little .qvw to reset the flag (NOTRUN) when task2 or task3 aborts (when failed).

Re: Tasks with multiple levels running into eachother

joshabbott — Fri, 26 Aug 2016 18:07:41 GMT

I think this may be the best option, thank you!