topic Re: QVMC schedule task on both failure and success of another in QlikView

QVMC schedule task on both failure and success of another

jindrichk — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have two tasks - QVD reload and front end UI reload. I would like to schedule both in QVMC as fast as possible.

What I have done is that I scheduled both on success reload of other one. This works fine until one of the task fail. In this case whole reload stop.

I wonder if there is some solution which will start the load of task on both failure and success of previous task. Or maybe start the reload of the same task in case of failure.

The failures are usually because of some temporary problems which are solved quickly so next reload are ok.

Does anybody have some idea how to solve this?

Regards,

Jindra

Re: QVMC schedule task on both failure and success of another

tresB — Thu, 09 Jul 2015 08:43:28 GMT

There is a trigger task in publisher 'On event fron another task' and Start On - Successful or Failed. You could possible set two tasks for both these cases, i.e. - one reload for 'Successful' and another for 'Failed'.

Re: QVMC schedule task on both failure and success of another

jindrichk — Thu, 09 Jul 2015 08:46:10 GMT

Thanks, but this means I need two copies of both projects as it is not possible to schedule one task in both ways. Probably possible way but I want to avoid this if possible as don't want to change two project in case any change will be necessary.

Re: QVMC schedule task on both failure and success of another

Gabriel — Thu, 09 Jul 2015 08:53:32 GMT

Hi,

What tresesco was saying is setup 2 trigger 1st for when the parent job is successful and the 2nd when the parent task fails.

You don't need two source document just reuse same source document

Re: QVMC schedule task on both failure and success of another

jindrichk — Thu, 09 Jul 2015 08:57:07 GMT

Hi,

but how to do that. There is drop down menu which allows to select only one option. How can I vcreate second trigger?

Re: QVMC schedule task on both failure and success of another

tresB — Thu, 09 Jul 2015 09:01:16 GMT

Add trigger one after another.

Re: QVMC schedule task on both failure and success of another

jindrichk — Thu, 09 Jul 2015 09:04:15 GMT

I guess this is not from Qlikview Managment Console, right? Is it Publisher? I'm not using this product.

Re: QVMC schedule task on both failure and success of another

Gabriel — Thu, 09 Jul 2015 09:15:12 GMT

Hi,

You have to create the second trigger exactly how you created the first trigger. Just click on the + sign

Re: QVMC schedule task on both failure and success of another

Peter_Cammaert — Thu, 09 Jul 2015 09:20:39 GMT

Indeed, they are suggesting solutions that are only available in the Publisher (multiple triggers)

The publishing features in a standard server (i.e. without the real publisher) are only very limited and many nice reload sequences can only be realized using "workarounds".

How about launching a batch/command file with two QV Desktop reloads from Windows Task Scheduler?

Peter

Re: QVMC schedule task on both failure and success of another

Peter_Cammaert — Thu, 09 Jul 2015 09:24:58 GMT

BTW the screenshots really are from the QlikView Management Console. As soon as you install a Publisher license, the Management Console gets a lot of additional tabs and views that allow you to configure tasks in a variety of ways. Unlimited flexibility almost.

As soon as you start to feel seriously limited by the lack of a real publisher, consider requesting a budget to buy one. You will not regret it.

Peter

Re: QVMC schedule task on both failure and success of another

jindrichk — Thu, 09 Jul 2015 09:25:32 GMT

Hi Peter,

I missed the info about Publisher in the first post. I was really thinking only about QVMC as written in post name. Forgot to stress it.

This using Windows scheduler is not helping in having the reload in "loop". I can schedule the taskon some time in QVMC same way as using Win Scheduler.

I wanted to have them one right after another,

Re: QVMC schedule task on both failure and success of another

Peter_Cammaert — Thu, 09 Jul 2015 09:31:50 GMT

You mean you want to schedule Task 1 -> Task 2 (whatever the outcome of Task 1) -> Task 1 (whatever the outcome of Task 2) -> and so on?

That is perfectly possible with a batch/command file. The Windows Task Scheduler trigger will fire only once, and then an unlimited execution loop will start. Is that what you want?

Re: QVMC schedule task on both failure and success of another

jindrichk — Thu, 09 Jul 2015 09:35:12 GMT

Yes, that is exactly what I want to create.

So I probably did not understand how you want to create the batch file. Can I ask you for some more details of how to handle this?

Re: QVMC schedule task on both failure and success of another

Peter_Cammaert — Thu, 09 Jul 2015 09:50:16 GMT

Well, QlikView Desktop can also be used to reload a document, even from a batch file. The command line sytax is something like:

"C:\PathToQVDesktop\QV.EXE" /r "PathToQVDocument\QVDocument.QVW"

This command will launch QV Desktop, load the document, execute the script, save the document (if everything went well) and close QV Desktop. Open a command prompt and test it.

Add two of these to a CMD file (one for each reload), preceded by a label (like :Start) and followed by a GOTO Start.

In batch/command files, you must expressly test for the outcome of a specific statement. By not doing this, you will ignore failure or success any proceed to the next statement anyway. Seems to me that this is what you would like to happen.

Peter

Re: QVMC schedule task on both failure and success of another

jindrichk — Thu, 09 Jul 2015 10:10:44 GMT

I have tried to run the test project which always fail using batch file via via running QV desktop in command line. The result is that the window with log and the error remains opened. Not sure if the result using win scheduler will be different but I gues it will not

Re: QVMC schedule task on both failure and success of another

Peter_Cammaert — Thu, 09 Jul 2015 10:39:23 GMT

You can avoid these pop-ups by placing the following statement in your script immediately before the part where things might go wrong (or at the start if you like):

SET ErrorMode = 0; // Suppress Error messages

Best,

Peter

Re: QVMC schedule task on both failure and success of another

jindrichk — Thu, 09 Jul 2015 10:42:40 GMT

Thanks Peter, this seems to be really a valid way how to hnadle it.

Regards,

Jindra