How to Notify Users

[Adrian]

I am building an application that executes work on a database server in the form of a stored procedure. This stored procedure taken an extensive amount of time to complete. Instead of having the user wait for the execution on the server to complete I want to code such that after execution of this procedure to notify the user when it completes. For doing this what method can I make use in my .NET application. Kindly someone help me out in this process to complete my task.

[techguru]

You can have a monitoring job with ajax to see if the job completed or not .. if the job is running for more then x min, then you can use mail component to send an email to the user..

[tushersmart]

You may use Atlas or Ajax to show user a progress bar during execution.
By this you also be able to provide user notification message after complete of that process..