Be honest I thought about it, but can't figure out how can use WAITFOR
here.
What should I pass to WAITFOR? It accepts time interval or time of the
day.

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

-----Original Message-----
From: Hajkowski Michael [mailto:michael.[Email address protected]
Sent: Wednesday, September 26, 2007 9:23 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


How about using a loop and a WAITFOR statement?

Mike


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

You are right,

But how can I make sure A will wait until B, C, D is done.
Like I said - as soon you start B, C, D it will get back to you telling
that they all started successfully and it will go to the next step.


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

-----Original Message-----
From: Hajkowski Michael
[mailto:mssqldba-ezmlmshield-x52594379.[Email address protected]
Sent: Wednesday, September 26, 2007 9:07 AM
To: LazyDBA Discussion
Subject: RE: jobs managing

You could have the jobs on server B, C and D write to an event table
when they complete so that Job A will wait until it sees the following:

EventTable

Job RunDateTime

B 9/25/2007 05:00
D 9/25/2007 05:23
C 9/25/2007 06:03

Then it could run.

Just a thought

Mike


-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x13204073.[Email address protected]
Sent: Wednesday, September 26, 2007 9: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



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



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




MS Sql Server LazyDBA home page