December 2, 2004 at 8:01 am
Hi, does anybody has a, or has a tip on where to find, a datamodel och a scheduler like Outlook's?
That is:
store in a table a "timeschema" containing when a scheduled task
should appear.
Tasks can happen daily, weekly, monthly or yearly.
When daily they can occur every n:th day.
Or evere workday (mond to friday)
When weekly they can occur every n:th week.
And on every day or a specific day or for example monday and friday.
When monthly they can occur day x every month.
Or first/last xday every month.
When yearly they can occur day x every y:th month.
Or first/last xday every y:th month.
/m
December 4, 2004 at 1:17 pm
Well, not much, but I would first have a look at the Outlook object model. This will lead you to those subtypes like mail, contact, appointment and so on... The rest you will you to do on your own. And maybe this one will help, too:
http://www.databaseanswers.org/data_models/index.htm
HTH
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply