How to do async execution

Is there any way to call several stored procedure asynchronously from within
another SP ?
I want to execute several SPs in paralle, calling them insidia a SP.
Something like:
stored proc sp1
begin
...
exec mySP1 (async)
exec mySP2 (async)
exec mySP3 (async)
end
so SP2 doesn;t have to wait unit SP1 finishes.
Thanks.i don't know if WAITFOR will work but have you tried it?
"PeyoQuintero" <pedroquintero@.earthlink.net> wrote in message
news:BK_8d.6601$Vm1.5770@.newsread3.news.atl.earthlink.net...
> Is there any way to call several stored procedure asynchronously from
> within
> another SP ?
> I want to execute several SPs in paralle, calling them insidia a SP.
> Something like:
> stored proc sp1
> begin
> ...
> exec mySP1 (async)
> exec mySP2 (async)
> exec mySP3 (async)
>
> end
> so SP2 doesn;t have to wait unit SP1 finishes.
> Thanks.
>|||PeyoQuintero wrote:
> Is there any way to call several stored procedure asynchronously from
> within another SP ?
> I want to execute several SPs in paralle, calling them insidia a SP.
> Something like:
> stored proc sp1
> begin
> ...
> exec mySP1 (async)
> exec mySP2 (async)
> exec mySP3 (async)
>
> end
> so SP2 doesn;t have to wait unit SP1 finishes.
> Thanks.
Asynchronous operation is really the domain of the client library and
would normally require multiple connections to the server. You can kick
off three separate jobs from SQL Server Agent that would call the three
SPs. You could also kick off three separate tasks from Windows task
manager that start OSQL sessions.
You could define the jobs interactively inside a SP and kick them off
one after the other. Each job would use a separate connection and they
would run simultaneously. To do this, create the jobs from SQL
Enterprise Manager and then script them out to see the TSQL to use. I
think you can define the jobs to auto-delete once they are finished.
David Gugick
Imceda Software
www.imceda.com|||I would do it from an application logic (vb.net / c# ...)
I never looked into how you ca achieve it with t-sql, apart if you are a
die hard and write an extended sp...
PeyoQuintero wrote:
> Is there any way to call several stored procedure asynchronously from within
> another SP ?
> I want to execute several SPs in paralle, calling them insidia a SP.
> Something like:
> stored proc sp1
> begin
> ...
> exec mySP1 (async)
> exec mySP2 (async)
> exec mySP3 (async)
>
> end
> so SP2 doesn;t have to wait unit SP1 finishes.
> Thanks.
>