Make an AJAX file that lauches long running stored procedure (2 hours) and keep the status updated. For each stored procedure launched, another stored procedure keeps the client informed about the progress in %, and this is the second stored procedure that should be called after the first one is called.
On the page, several stored procedures could be called simultaneously, and therefore several progress updates can be seen.
If the long stored procedures as input parameters, it should be automatically explored using SQL parameter discovery and the user could have the possibility to fill those parameters on the web page.
in [login to view URL], the list of available long running stored procedures is informed (not the parameters since they are aut discovered).
WWF Workflow is required on the web server to launch the main stored procedure, then the second stored procedure for client progress notification, and perform any required rollback on error.
Several workflow can be launched independently.