I have a custom app for which the first notification is sent from a scheduled jobs. The scheduled job runs everyday and goes through a table and it finds all the records with expiry date 60 days from current date. that would be the first notification.
After the first notification which is sent for records that expire either at 60 days or 90 days , subsequent notifications are to be sent based on the following conditions:
Second notification is a monthly notification i.e. essentially a monthly notification
for thirst notification when its 30 days before expiry date , there should be a weekly notification.
I was able to implement the first notification and not sure how to proceed with the second and third notification.
Could any one help me with the conditions?
