I have a job that reads a pipe (|) delimited file, using a UniversalDataReader, and writes the contents to a database table. We a have an issue where the supplier of the files occasionally sends a file with no data in it. Is there a way to trigger an alert or force an error in the clover server when this happens?
Hi Mike,
The best approach would be to use a JOBFLOW which would first check the size of the file and if it is greater than zero, then execute your transformation graph (via ExecuteGraph component) feeding the path of the file to it. In the zero size case it can send e-mail or just fail, and then you can have a listener setup on your server which is triggered whenever that particular JOBFLOW fails.
Look at https://doc.cloverdx.com/latest/designer/listfiles.html for ListFiles jobflow component reference.