Redwood - how to create a job that will look on SFTP if file is existing or not

[philip0929]

Hi guys,

I would like to seek your help. We have a job requirement in Redwood.

1. We need to check if the file for current day is existing in SFTP server. The directory has many files in it and the job need to find the file for the current day.

2. Send an email to recipients that the file for current day is existing.

[Matt_Fraser]

Hi Philip,

I have removed the tags related to EWM from your question, as there's no indication you are asking about the "Enterprise Warehouse Management" product. Those are not "Basis" tags, they are product-specific.

Regards,
Matt Fraser
SAP Community Moderator

[gmblom]

Hello,

There are multiple ways to do this, look for instance in this thread:

https://unix.stackexchange.com/questions/285472/how-to-list-files-and-only-files-via-sftp

depending on whether the file is there make job error or complete, this gives you the final status handling option to decide whether to send the email or not in the next step.

Regards Gerben