I am running the Data Driven Subscription in a Cursor - for sending out unique instances of the report to individual locations. The problem I am running into is that I have to hard code in
WAITFOR DELAY '00:00:05'
Before the next fetch or it returns the default results (does not pass the new set of parameters).
Any thoughts on a delay solution that is not so arbitrary? I will eventually have a couple of hundred instances going out and if this "reset time" is variable I will have to make it a really long interval if there is no standard.
Thanks,
Bill