Looking for patterns of running repeated tasks

[Mehdi]

Hi
I've got a scenario for developing a component or application for my
web app. to send some notification issues every some seconds to the
app. users. the issues are added by users themselves and will send at
the appropriate time (for example I add a reminder for the next
saturday at 13:28 AM, it will be saved into a database and this
component/application should send it at the specified time).
I thought about writing a windows service that every one second checks
the DB and sends the messages for the current time.
Now, I'm looking for other alternative ways that I can do for this
purpose.
Do you know any design/architectural pattern for this problem?

Thanks for giving me your ideas.

[Michael Nemtsev]

Hello Mehdi,

MI thought about writing a windows service that every one second
Mchecks the DB and sends the messages for the current time.

check the DB for the Notification features, such DB as SQLServer/Oracle have
them, and use it to inform your service when time is out.
Another approach is to use notification when new entry is added to DB to
send new scheduler time to your service, and service (using Timer class)
should handle the notifications

---
WBR,
Michael Nemtsev [C# MVP] :: blog: http://spaces.live.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche