• The usual practice what I have observed is "crude". The FTP initiates at certain time during the day, which is believed that the FTP host server will have the files. Hence, no issue. If there is a delay, the package has be run manually.

    Alternately, one can come up with better modular designs such as, emailing or updating a certain flag when the files or the load is made available on the FTP server. The file transfer can then be triggered after verifying the flag status.

    Raunak J