I need a java servlet that checks ( 15 minute intervals) a mysql table for emails to be sent. When the email schedule datetime occurs use javamail to create and send the email. Should also be able to send html emails. I'm not sure what's required to send html emails but it should be able to. I'll need your guidance for that.
There should also be a join with the contact table to verify that our contact's send_email_ok flag is True.
After email is sent the send_time should be updated
My webhost runs resin to manage tomcat...
To get the scheduler to run at regular intervals resin allows run-at periodic services. You can find out more at <[login to view URL]>
Also install and use Jakarta Log4j to log possible errors and exceptions
Possible errors and validations: email address should be validated, if email is incorrect I should be sent an email and it should be logged using log4j
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Java