Hi, I am facing following problem with our shopping cart application. Our organisation running one shopping cart site ,which is accessible on internet and intranet (within organisation).Problem is as follows, We want to introduce escalation with our site.Requirement is that whenever party books an order , it should be processed within 24 hrs of time span after booking time if it will not happen , system should send email reminder to corresponding authority. Can anybody help me please?Can anybody has suggestions/ideas? We are using tomcat 5.0.28 with microsoft windows server 2003 and sql server 2000 as database.
I've written several utilities that are similar to what you describe. They monitor services, create periodic reports, check log files for errors, remind people who haven't taken required actions and so on. I usually just write a little Java program to directly query the db and send notifications via JavaMail (as Ben suggested). These programs are run at intervals (some hourly, some daily, some monthly) by cron on Solaris. If you are on Windows, look at "at". If you want an all-Java solution, there's java.util.Timer.