I have a application which refreshes every 5mins and this file is used to send email notifications through alerts every 1hour(let’s say 10A.M,11A.M,12A.M etc). While setting up the trigger have given the condition that the application has to send the email notification (trigger) in the first 15mins. The reason for giving 15mins is to handle any chance of application refresh failing.
As we have clustering(Server1 ,Server2) implemented every 5mins the application runs randomly in the different servers and it sends out maximum of 3 email as we have given 3 chances (15mins I was saying in my previous comments).The problem here is let’s say the application has on Server1 run at 9A.M and it has sent email to users. On the second run at 9:05 AM it runs on different server and send the email notification again which I don’t want it to see.
Is there any way that to find out the trigger has been successfully sent the email notification to users or any suggestions to handle this situation are most welcome.
