We have several File trigger jobs, monitoring several different paths/folders for specific files.. For the most part, they work as expected, however at times, the triggers do not fire. No errors, just files get ignored, and subsequent files will work, and so on.
This has been happening for quite some time, and can't figure out why? Why would it work for 100 files or more, then all of a sudden ignore one, then work again! Trigger uses a file mask, nothing special about the files that get ignored, and if I manually run the file trigger, the job will work!
Example of files myfile1234.csv mask myfile*.csv
Any suggestions, thoughts are appreciated.
Thanks.