topic Batch File to return success or failure in QlikView

Batch File to return success or failure

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

Hi Folks,

I have a requirement that at a particular time a batch file should run, fetch a file from SFTP location and then perform QVD reloads that will sue the file. I would like to achieve the same by creating a Job A in the QMC that will run the batch file and get the file. On success or failure of Job A, Job B should create the QVD's then the next Job to reload teh dashboard. Note that on Success of A, B will run, on success of B, C will run. There is a scenario where I would like to force fail the job. Say we have not received the file and Job A should fail which will send out a email. Then there will be manual intervention to look at getting the files.

How do I make Job A fail which is a batch file execution, when the batch file did not get any file from SFTP?

thanks,

Rajesh Vaswani

Re: Batch File to return success or failure

danielrozental — Tue, 08 Oct 2013 16:57:27 GMT

There isn't a clean way to make a QVW Script fail, there is no exit(error) that will cause the desired behaviour.

You should just try to read a file that doesn't exist or something like that

LOAD * FROM FORCE_ERROR.QVD;

Re: Batch File to return success or failure

Fri, 11 Oct 2013 12:35:16 GMT

You can have an alertmail inside your Qvw application that will send out an alertmail when the file has been updated with a value change. But there is no check that will "look" for a file to be fetched, all based on data being loaded. QMC acts on failures vs success, so that can´t be used in such scenario either.

Best would be if you implement a load of somekind inside the qvw that can trigger an alert mail, when the file is fetched.