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.
I have been able to run multisession on SQL Assistant, opening new windows, pasting command on each one, and then pressing F9 (Parallel run on each window)
Don't know if Teradata studio can do the same