All Forums Database
TD_Raj 50 posts Joined 05/10
05 Nov 2014
how to run multiple stored procedures in parallel ?

Hi
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:

CALL TEST_PROC1()
;CALL TEST_PROC2()
;CALL TEST_PROC3()
;CALL TEST_PROC4();

However this does not work.
Any suggestions.
Thanks
Raj

 

Raja_KT 1246 posts Joined 07/09
05 Nov 2014

How about a scheduler? Checkin with  version and package such that they are run in parallel.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

TD_Raj 50 posts Joined 05/10
05 Nov 2014

then all the procs need diff session.
can we do something within same session ?

Raja_KT 1246 posts Joined 07/09
05 Nov 2014

Can you stuff your other stored procs inside one.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

ToddAWalter 316 posts Joined 10/11
05 Nov 2014

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. 

You must sign in to leave a comment.