wonderful world wonderful world - 10 days ago 7
ASP.NET (C#) Question

Stored procedure stopped when Browser closed

A long running process (SQL stored procedure) is started by calling ExecuteSqlCommandAsync. The stored procedure returns data as long as I have the browser up and running. When the browser is closed, the stored procedure stop or rollbacks. Is this the expected behavior? If I have to run a long running process, what should I do to make sure the long running process will run.?

Answer

The stored procedure that needs to be called can be wrapped in a SSIS package, and the web app can call the SSIS package directly will help to run the stored procedure as task. The Browser can be closed but still the task will run.