I am trying to design an system which can trigger certain events if an action has not taken place. e.g Suppose a person needs to fill 3 forms every hour and if he hasnt then a trigger should take place.
The condition will be different for different users, each hour, each day , each week.
One way is to keep checking the database every minute to check if the action has taken place. But when i have 1000s of users, is this even feasible, also by the time I check every user a lot of time would have passed by which will result in lot of fails.
Any design suggestions?