March 12, 2003 at 8:20 am
I am trying to figure out how best to deal with recurring events in a database. I want to be able to set an event that has a start date, no end date and can be recurring with different parameters (such as every monday, every month on the first day of the month, every month on the first thursday of the month, etc.) Does anyone have any pointers to documents on strategies for dealing with this? Right now I am leaning towards handling a lot of logic in my application layer but I would rather find an elegant T-SQL method for dealing with this. Of course, right now, I can't even figure out the best way to structure my tables.
Thanks,
Alex Gadea
Apptik Inc.
March 16, 2003 at 9:06 am
Look at the job scheduler.
It does very similar things and you can get some ideas from the structure of the tables.
Cursors never.
DTS - only when needed and never to control.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply