We are building a workflow, when the workflow starts, few steps are executed i.e.
- Create/Open proposal - Takes around 30 sec
- Perform calculations - Takes around 90 sec
- Send notification to user(s) to approve or reject - Takes around 10 sec
As 4th step we will have to wait for X no. of days and send out reminder to user to approve/reject the proposal if it is not approved/rejected.
We are planning to implement 1-3 using event driven architecture. At the end of step#3 we are thinking of writing a record to DB. step#4 will be developed as Azure function which runs at regular intervals to sweep DB table for pending notifications and send out notifications to users.
I would like to understand if there are other better implementations of step#4 in native cloud design on Azure.
Please suggest me if there is a better way to implement end to end flow other than event driven design
