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.