Actually, I'm sorry I forgot to mention that that's what I have.
I do have B, C, and D as linked servers on A.
I do exactly the same way you described it, but I want to start them all
at once and not sequentially.


Albert Frazer
Home Decor Products, Inc
www.hdpi.com
732-593-3637 (office)
732-570-4465 (cell)

-----Original Message-----
From: Neal Sivley [mailto:[Email address protected]
Sent: Wednesday, September 26, 2007 9:14 AM
To: Albert Frazer
Subject: RE: jobs managing

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Can you create a Linked Server from B, C, and D on A then create you Job
such that

step 1
Execute ServerB.Database.dbo.SP
Execute ServerC.Database.dbo.SP
Execute ServerD.Database.dbo.SP

Step2
Execute ServerA.Database.dbo.SP

Thanks,
Neal

-----Original Message-----
From: Albert Frazer
[Email address protected]
Sent: Wednesday, September 26, 2007 8:02 AM
To: LazyDBA Discussion
Subject: jobs managing

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 [Email address
protected] 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)





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


________________________________________________________________________
_____
Scanned by IBM Email Security Management Services powered by
MessageLabs. For more information please visit http://www.ers.ibm.com
________________________________________________________________________
_____

________________________________________________________________________
_____
Scanned by IBM Email Security Management Services powered by
MessageLabs. For more information please visit http://www.ers.ibm.com
________________________________________________________________________
_____



MS Sql Server LazyDBA home page