Sorry, was too busy.
As a matter of fact I found a different solution. On this page (below) I
took Ken Henderson's SP and modified to suit my needs. It really works
great. If you want to I can send you sample code. It's just a few lines
of code; you can basically use it anywhere you need start a bunch of
SPs, processes or jobs simultaneously on more than 1 server.
Again, thanks for all your help!
Albert Frazer
Home Decor Products, Inc
www.hdpi.com
732-593-3637 (office)
732-570-4465 (cell)
-----Original Message-----
From: Tom Roush [mailto:[Email address protected]
Sent: Friday, September 28, 2007 1:17 PM
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 did you end up solving this problem?
I'm just curious (and also because I detest DTS)
: )
Happy Friday,
Tom
-----Original Message-----
From: Albert Frazer [Email address protected]
Sent: Wednesday, September 26, 2007 10:27 AM
To: LazyDBA Discussion
Subject: RE: jobs managing
That's what I was afraid of...thanks all of you for help.
Albert Frazer
Home Decor Products, Inc
www.hdpi.com
732-593-3637 (office)
732-570-4465 (cell)
-----Original Message-----
From: Bowman Rita A.
[mailto:mssqldba-ezmlmshield-x79494091.[Email address protected]
Sent: Wednesday, September 26, 2007 12:42 PM
To: LazyDBA Discussion
Subject: RE: jobs managing
Albert - looks like a good candidate for a dts package.
-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x99630414.[Email address protected]
Sent: Wednesday, September 26, 2007 9:49 AM
To: LazyDBA Discussion
Subject: RE: jobs managing
No, I don't want to do this way.
Here what I have now (job located on A):
1. backup DB
2. zip the backup file
3. copy zipped file to B, C, D (batch file)
4. unzip backup file on B, C, D
a) exec usp_unzipB
b) exec usp_unzipC
c) exec usp_unzipD
5. restore database from unzipped file on B, C, D
a) exec usp_restoreB
b) exec usp_restoreC
c) exec usp_restoreD
Here what I want to accomplish:
1. backup DB
2. zip the backup file
3. copy zipped file to B, C, D (batch file)
4. unzip backup file on B, C, D (start unzip on all servers
simultaneously)
5. restore database from unzipped file on B, C, D (start restore on all
servers
simultaneously)
This way I will cut down job execution time drastically.
Albert Frazer
Home Decor Products, Inc
www.hdpi.com
732-593-3637 (office)
732-570-4465 (cell)
-----Original Message-----
From: Music Everett
[mailto:mssqldba-ezmlmshield-x15614854.[Email address protected]
Sent: Wednesday, September 26, 2007 9:31 AM
To: LazyDBA Discussion
Subject: RE: jobs managing
You could have the job on Server A start the job on Server B; When
Server B is done, have it start the job on Server C; when Server C is
done have it start the job on Server D; when Server D is done have it
start the job on Server A that relies on the other servers.
No trees were killed in the making of this email. However, a large
number of electrons were diverted from their original destination.
-----Original Message-----
From: Hajkowski Michael
[mailto:mssqldba-ezmlmshield-x1043163.[Email address protected]
Sent: Wednesday, September 26, 2007 6:23 AM
To: LazyDBA Discussion
Subject: RE: jobs managing
How about using a loop and a WAITFOR statement?
Mike
-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x32774569.[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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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