Count the files and send it to PI
A job runs weekly and creates 6 files on one of the prod folders in a windows system. The files are FTP to PI. Before picking the files we need to ensure that the count for the files on that folder is 6. If it is 6 or greater then we can pick all those 6 files and send it across to PI (also with archiving it on another folder structure in the legacy system) where PI will send it to another system. If the count is less than 6, then we do not need to do any thing. If count 6 is reached and the files are picked, reset the counter to 0.
The source system is Windows. On a Saturday, if we run a job at say 1:00 pm then within an hour or two, if 6 files are not present then an alert/mail should be sent to the Business informing that 6 files are not present in the folder.
Please suggest how to approach on this.