Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to trigger the reload of a single document after a two or more reload tasks are successful?
I am not looking for a OR clause, rather if A and B and C have successfully reloaded, reload D.
Document A, B, and C create .QVD files to be loaded by Document D. I need A, B, and C to successfully complete, then have D trigger to reload. If A, B, or C fail, D should not be reloaded.
James
Yes, this is possible if you have a publisher license.
Yes, this is possible if you have a publisher license.
Hi James
As Bill said this is possible only if you have a QlikView Publisher license.
What it actually does is slightly different but it achieves the same thing. When one of the listed reloads finishes it checks to see if the others all completed successfully within a definable time period. If they have it will run the reload, if not it won't.
Matt
This can be done by adding Task Dependencies in QEMC > Documents > Source Documents > Triggers >Task Dependencies.
Good luck,
B
Matt,
In V11, I see the trigger of 'On multiple events completed', is this what your are referring to?
James
That is it.
It appears that a combination of 'On multiple events completed' trigger and the task dependencies is the solution.
To test this theory, I setup a pause task which triggers 4 document reloads. The first 3 reloads are very fast, the 4th takes about 2 minutes to complete. I then setup a 5 document to be triggered by the succesful completion of the 4 documents. However, without the dependency check, the 5th document would start reloading before the long running 4th document finished.
Thanks to all!
James
Hi B,
I had a question on your point,
I had task A say QVD generator, and Task B should run after the QVD Gen.
I scheduled for Task A & B at 08:00 AM but for Task B I given Task Dependency as Task A, But both are starting at same time and Task B is reflecting the old data rather than the refreshed New data.
Can u suggest on thsi.
Thanks
Santhosh N
Should Task A and Task B really be dependencies? Is Task based on the QVDs in Task A?
If Task B needs components of Task A, then it should be triggered on the successful completion.
Based on your original question, Task D should be triggered following Tasks A, B, and C. You can add dependencies on other jobs, but dependencies only checks that the job completed successfully, not that it is still running.
If Tasks A, B, and C need to run concurrently, then I would either trigger Task D on successful completion of the longest running job, or schedule the job at a time when the other task should have completed by 5 or 10 minutes.
Hope this helps,
B
Thanks D.
This solutions solves my problem