We currently have a piece of sql that runs that can take a long time, over minutes wouldnt be unusual purely due to the amount of data that is being processed.
I have been asked to put a quick user interface together just so that marketing can kick this job off them selves.
So basically on a button click i will be calling a stored procedure that will run this sql.
What i am worried about is the amount og time it takes to run, will the code timeout etc?
what is the best way to handle this kind of thing? A thread or webservice or?.....
This is the first time I have had to do something that comes up against this issue so dont know what the 'norm' is for handling.
any advice would be appreacited on best practice or at how it would normally be handled.
I would need to some how let the user know that the job has finished via the ui.