I am developing a web application (college project) in which i have a library module. In this we are charging the students who had not returned the book in the due time.So, my problem is I want to send them a mail intimating about the status of the book they had taken.
This should be done automatically and I don't want to send the mails manually. I want to use triggers for this which automatically fires as the due date is completed. So , please tell me how to write and invoke the trigger when the due date is crossed for a specific student.