Take the 2-minute tour ×

In my struts application tickets are being raised and they are stored in db with time of creation .

Now my requirement is to raise a event after 24 hours of that token created time.

I am aware of a Quatz schedular which can raised an event for every 24 hr. But my requirement is based on the time in some row of the db.

Can I find any tool such as above to do this?

How to do it with minimum hits to data base?

Please can some one suggest me some ideas? I am using the MYSQL may be needed to answer.

share|improve this question
add comment

1 Answer

In one of previous projects, we used to have reminders configured by user to be fired arbitrarily,

  • based on the due date of a project,
  • at some point in future
  • based on the inactive period of a project etc.,

We used to have a Quartz Job that would run every 5minutes and identify the project records in the database that satisfy one of the above criteria and retrieve them and perform an action (in our case, we needed to send a reminder email to some recipients configured).

Based on your requirement, you can configure a similar job and decide on the periodicity. If your table is too large, you can run the job every 5min/10min which means the event might be raised later than 24 hours by a 5min/10min delay. If your table is small enough, you can run the job every minute.


share|improve this answer
Thanks for Replay ! –  Das Oct 31 '12 at 8:31
I was planning for the same but the number hit to the db is major criteria . I was hope-ing their might be some push based approach db directly give some hit about the above criteria ! –  Das Oct 31 '12 at 8:34
accepting the Solution as this definitely serve my purpose –  Das Nov 1 '12 at 4:42
add comment

Your Answer


