How could a notification be configured to be scheduled at a point in the future?
We have a requirement to send certain notifications after an ‘age’ threshold has been surpassed.
This frequently requires a non-standard table or view (one not included in the baseline notification function) and would need to run after a date comparison determines that an item has exceeded an age based on a date stored in the table, and the current server time? - This seems to present a challenge as no server fields have changed
Has anyone successfully used non-standard tables for notification triggers?
How have you been able to handle the notifications which need to be sent in the future?