I have to run few procs in parallel.
I have created a wrapper stored procedure which calls all the procedures. Presently it calls procs in sequence. How can I call procs in parallel ?
I have tried msr eg:
However this does not work.
If you wish to have two or more SPs run concurrently, they must be run on separate sessions. We do not have enough information about what is going to happen inside the procedure to be able to run them in parallel like we do with parallel steps.