This content has been marked as final. Show 2 replies
You would typically run an overnight job (kicked off via a Java scheduler like Quartz or a native scheduler like cron) that queries the database for the durations you specify. The job could run on a more frequent interval if desired, perhaps hourly. You would have a table with a series of timestamps, such as view_timestamp, modify_timestamp, etc. Alternatively, you could have a table that has a series of timestamps such as event_name, event_timestamp. That table would need to be linked to the original table via a foreign key.
So, really, it's simply writing a query and iterating over the results, sending them to the appropriate email recipients. You probably could do the above without even involving Java, depending on the database you are using.
Thanx Sais, for your reply, I,ve solved my problem using java scheduling.