SQL Apprentice Question
I need some help to design the database or table for my
application on scheduling task. My application is to do some scheduling
task based on daily, weekly and monthly. On the daily the choice are
everyday, weekdays, or every what ever value of the days. On the daily
the choice are every what ever value of the week on the selected days.
On the monthly the choice are on what date, on what day of what week,
and on selected month. My scheduling task choice is the same as
Microsoft Windows XP Professional Version 2002 SP 2 scheduling task
choice. I want to store these choices on database so I can check the
value using timer
Celko Answers
>> On the daily the choice are everyday, weekdays, or every what ever value of the days. On the daily the choice are every what ever value of the week on the selected days. On the monthly the choice are on what date, on what day of what week, and on selected month. <<
Do you have a calendar table which identifiies all of these groupings?
Do not try to compute them.
Wednesday, May 31, 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment