The Definitive Guide to Data Quality
I'm a bit lost on how to test if pdf files with wildcard (MyName_*.pdf) are available in a specific directory. I think that tFileExist can't have "generic" names as *.pdf, but the files I have to manage have random names (except extension file that is pdf). If I use tFileList, it works with generic names but how can I send an email when no files are found, and if files exist, I have to iterate to send them to assigned recipient.
To be clear:
Test if at least one file exists
If no files then send a message to warn
If one or more files exist, process them
Thans for your help.
I have a job which lists file in a directory and process it, if no files r found a mysql function is to be called .