Can I use a wild cared to pull multiple files from a folder using the SFTP_JAVA job?
Yes. The SFTP_JAVA job can use a wild card to pull/get multiple files from a specified path. Ensure that the sftp_java job is assigned to the correct agent, and use an asterick (*) in the remote path filed.
File*.txt would return all files that start with File and End with .txt.
File_*_.txt would return all the files that are called that fit that description