Run long running store procedure in SQL with no output result, no need to stop application , just pass flag to application running process only.

See more:

C#

ASP.NET

SQL

I have huge amount of data into tables and get extract result from it takes near about 60 Min,

So Till that time my application get stop or we can say in wait.

So,My question is i need to call store procedure from c# code and i no need output from it.

Please describe me how to run that procedure in backend without stop application in wait for user.

What I have tried:

I handle backend procedure with table and auto mail if record insert into temp table.

I tried BCP utility but and triggers but it also takes time.