Hello everyone,



I want to execute SP on ServerB, ServerC and ServerD simultaneously
initiated from ServerA.

Or this could be a job on each server, but the problem is I need for
ServerA wait until all jobs (or SPs) are done on each server.

When I run execute ServerB.msdb.dbo.sp_start_job @job_name it returns me
that the job started successfully and it will go to the next step.

I want to wait until it finishes.



Any help appreciated.



Thanks,



Albert Frazer

Home Decor Products, Inc

www.hdpi.com <http://www.hdpi.com>

732-593-3637 (office)

732-570-4465 (cell)




MS Sql Server LazyDBA home page