Comments by Gokhan CETIN (Top 3 by date)

I think I can not explain my problem :) My problem is not database performance. Simply; I want to create schedule job for x date on future which in some customer data.

Classic solution which i told is that;


example;
-Table Name: ScheduleWorker
-Columns: ID, Query, timeInterval,Action,IsActive

1.Create a windows service
2.Create a Timer for each ScheduleWorker Row
3.Set TimeInterval to Timer
4.Create Tick event for execute Query
5.Execute action for Query Results

Query could be Storedprocedure or text script...

If I create simple schedule worker, It always selecting data on database for each timer event fire. This solution could be use long timeIntervals. For example; work one time on a day(exp:02:00 am) for sending message for say to happy birthday which customer birth on this day.

Everything is ok for above senario.

Now I will try to explain my problem with new senario..

I have a new customer and customer signed new contract on today at 01:00pm. So I want to send welcome message after 5 day + 2 hour + 1 min from signed date(I know this sample was a little extreme :D). So if I use classic solution fro send message to my customer, I have to search database each minute for find this customer(where signdate = DATEADD(minute,-122,DATEADD(day,-5,GETDATE())))

So I dont want to this. I'm trying to learn that; does anyone using diffrent methods for executing this senario.

Actually best solution is that; add new row into Task Table When customer signed on contract. then always check just one table. But now; I have a current big CRM application and I cannot implement that insert codes on each action methods..

I'm sorry my english :) I tried to explain my problem :) I know it is very complicated model. I just try to find new ideas, and doing brain storming.

thanks again.