stored procedures - Asynchronous Storec Proc without waiting for completion -

I have a client application that erases the data in the raw table This client application creates an asynchronous call in a stored procedure Which actually parses in the raw data table. This processing is controlled by a stored procedure. It can take up to half an hour to run the stored procedure. We want the client to call the application to exclude the stored proc and stop running completely. As soon as we kill the client application, which calls the stored procedure, the stored procedure is executed.

What is the best way to get it? I do not want to run a job on the server I need client applications to trigger this processing. A database trigger (my first consideration) does not resolve this problem because it does not meet that insertion, unless the stored procedure that triggers the trigger call is complete.

Here is the Async method I am using LINQ. Can I modify it somehow? Or do I need a new design altogether?

  partial class metadatacontact {Representative Processcomple Seqal 2 Delegate (Int Frequency ID, Int. Cycle ID); Public Zero Process_CompleteCycle2Aynync (int? FrequencyID, int? CycleID) {Process_CompleteCycle2Delegate Full ProclamationGate = New ProcessCamilyCal 2 Delegate (this.Process_CompleteCycle2); IAsyncResult async = fullCycleDelegate.BeginInvoke (instance id, cycles, blank, blank); }  

Look for a reliable and consistent way of the transaction.