I get around 8000 requests per day on an average. Hence, there could be around 30,000 open/unattended requests in the system at a given point of time. All requests are tagged with expiry date/timestamp. How to check and trigger the escalation for the open/unattended requests that have expired? The escalation triggering should be with minimum or no time lag.
If I create and schedule a SQL batch job which runs every 5 mins to check and escalate the requests, then there would be time lag of 5 mins for some requests.
Loading
Sam HobbsPosted Mar 7, 2012, 1:46 AM
As best as I understand the question, you run a SQL batch job and you are asking how to do whatever the SQL batch job does. It does what you need done so I do not understand the question.