Hello all,

Here's the (relatively) short version. I have some ASP.NET intranet apps that i've made that interact with a 3rd party data system. After this datasystem is populated with a new "batch", the system then checks for any "alarms" and then (if there ARE any alarms) it puts in one or more records for this "batch" into an "alarms" table.

I'm not sure of any way of finding out when, exactly, the 3rd party system's processing is complete. For example, after populating a record into the database, I don't have any way of telling if there are any "alarms" or not unless I query the alarms table over and over again until either 1) I find a record that matches my criteria, or 2) some time elapses.

With VB.NET I can just do a thread.sleep for about 30 seconds after the population has been initiated and it is enough time for the3rd party system to fully do its thing. However, i cannot for the life of me figure out how to make an ASP.NET app pause for 30 seconds before continuing processing.

Thread.sleep in the ASP.NET app seems to do absolutely nothing.

Is there any way I can:
1) Implement some way of notifying my ASP app that the 3rd party system is done processing ? (runs on SQL Server which I have full access to)

or

2) Pause the ASP app after initiating the 3rd party population, and wait 30 seconds before continuing with my SQL query of the "alarms" table?

thanks........ (sorry this is so long!)