Help in need to have an opinion about Scheduler -> Email notification
Hello,
I need help. Is there a way to modify or create function that will send an email if there is overdue record lets say 1 hour after the record is overdue? I tried creating a scheduler (cron) to run everyminute but it gets expensive and it will always call the database. Is there a way to just simply get all list of records and update the list if there's modified/created record and even i run it every minute atleast it will not just call direct from database?
I need help. Is there a way to modify or create function that will send an email if there is overdue record lets say 1 hour after the record is overdue? I tried creating a scheduler (cron) to run everyminute but it gets expensive and it will always call the database. Is there a way to just simply get all list of records and update the list if there's modified/created record and even i run it every minute atleast it will not just call direct from database?
