Scheduler based Process Model

Question

There is a requirement to trigger a scheduler at 2 PM , 10 PM and 6 AM. When scheduler will trigger, it will invoke an API by passing the last execution time to fetch set of data between last execution time to current time. Say for an example, if scheduler runs at 2 PM, then it will pass 6AM as parameter to the API so API can return data between 6AM to current time (i.e. 2PM )interval. any suggestion how to implement this following the OOB configuration? TIA

Mathieu Drouin · Answer

If you absolutely want to avoid having to create a database table, you could always run a process report to get the time at which the last instance ran. 
 Also, as a side note, I think I would use the last identifier of the data subset instead of the time as the parameter.

Stefan Helzle · Answer

I implement such things by adding a update/insert timestamp to the data and then ask the API for any updates after that date. Relying on some process execution is dangerous as that process might have failed.