Why do you use a dts and then just schedule it...

Your tasks can be conditional

Vanessa Fredanus- van Gelder| SQL DBA | DXS Systems | Tel. +27 21 853 3317|
Fax. +27 21 854 7953

You must be the change you want to see in the world. Mahatma Gandhi





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





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



---

DXS - The Essential Healthcare Information Solution
http://www.dxs-systems.com/



DISCLAIMER:

This communication (including any attachments) may contain confidential or proprietary information. If you are not the intended recipient and you have received this communication in error, you should destroy it without copying, disclosing or otherwise using its contents and notify the sender immediately of the error.

Internet communications are not necessarily secure, and may be monitored, intercepted or changed after they are sent. DXS and its subsidiaries do not accept liability for any loss you may suffer as a result of interception, or any liability for such changes.

MS Sql Server LazyDBA home page