Performing Asynchronous operation

[RJN]

Hi

I have 2 operations to perform one is to upload data and the second is
to generate report. Both take huge time(more than 20 mins and I believe
by that time session would have expired) and hence has to be done
asynchronously.

For uploading data, user will click start button and the asynchronous
operation has to start immediately.

For report generation, user will enter a time when the report has to be
generated(weekend date time) and press start button. The asynchronous
operation should start only at this designated time.

How can I do the above 2 operations?

Thanks

rjn

 

[R-D-C]

You need to read up on threading or use an asynchronous web service for your
first problem. Check out http://www.15seconds.com/issue/031124.htm.

For the second item, you don't say what your system is. If SQL Server, pop
the date and time into a field that can be scanned by a SQL Agent Job every
ten minutes or so. When the record is within ten minutes of the current
time, fire off a stored procedure.

If not SQL, you could achieve something similar using a file and Windows
Scheduler.