This content has been marked as final. Show 4 replies
Is it possible to modify the profile to include a nextRunDate field? Every time a service is run, it updates nextRunDate. Then when you run a query to find what services to run, look at the nextRunDate.
Thanks for your reply. It's a good idea. I'll try that. Please also give me some ideas on how to run the query with the new field nextRunDate . In my previous example, if I run the query as 10/23/06 as criteria , what the infor should I use for query? Is this the way to approch? I convert 10/23/06 to Monday, then I look schedules on Monday? How about the profile that happens on every second Monday?
As usual in programming there are numerous ways. One approach would be to have an updateRundate method. If service runs everyday increase nextRundate by one, every week increase by 7 etc.
I think I got what you meant. I'll try it out. Thanks for all your help