Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rajeshvaswani77
Specialist III
Specialist III

Batch File to return success or failure

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


2 Replies
danielrozental
Master II
Master II

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;

Not applicable

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.