How to schedule CPI SFTP Sender with multiple on time triggered daily?

[stephen_xue]

Hi,

I have a very normal requirement: the SFTP sender is to pickup files at 2pm and 7pm twice daily.

Whereas cannot find a straight way to schedule it in the adapter configuraiton. Do I need to create two iflows, one will be triggered at 2pm and the other will be triggered at 7pm daily? it looks a bit ugly.

Regards,

[former_member1924 · Accepted solution]

Hi stephen.xue,

We could schedule twice but not exactly at 2pm and 7pm. But with below example you could schedule at 2pm and 8pm if that helps.

So the interface would poll at 14hrs and again at 20hrs (because of retry is every 6hrs).

There is no option to retry after every 5hrs else we could schedule at 19hrs as well.

Hope this helps !

thanks and regards,

Praveen T

[former_member739123 · Accepted solution]

Correct Praveen,

Even I too tried to check that option and found we don't have every 5hours option available on schedule parameters.

Regards

Deepak

[stephen_xue · Accepted solution]

thanks for your proposal. i think this is a one i need. brilliant idea. haha.

[Sriprasadsbhat]

Hello Stefen,

I would suggest you to raise a ticket to LOD-HCI-PI with above limitation.You can configure single Iflow to achieve above .

Regards,

Sriprasad Shivaram Bhat

[stephen_xue]

thanks for the suggestion. i assume Praveen's proposal looks better to me.

[kc_kristris]

Hello Stephen,

The solution provided by Sriprasad (above) to tweak the i-flow looks good.

I have one more solution to this, just in case if "you are not deleting the file" from your SFTP after polling the file.

1. Hold the execution time in a property parameter ${date:now:yyyy-MM-dd'T'HH:mm:ss}

2. Using router (condition -> if time = 2 PM or 4PM) you can continue the processing

3. Schedule your i-flow for every 2 Hrs.

Just a thought to handle this case...

Regards,

Kris

[stephen_xue]

thanks Kris for your proposal.