Hi,

It is advisable to utilize a scheduled job, as this will facilitate the specification of the time frequency. Furthermore, consider using a field or flag from the table to establish the trigger condition. Additionally, prepare a notification template and invoke it through the use of a script.