Vaibhav has given you some leads how you can start your work already.
Here, I just would like to suggest, DO NOT SEND MAIL/SMS from TRIGGER. Instead, you can push the data to be sent to a different table and Configure a job to send the email/SMS. This way, you will have an asynchronous method which would be the best option considering the performance of your system. You can even add logging(custom) for your mail events as well. Hope this would help you...
No comments:
Post a Comment