Thanks Stephen, definitely I will try this.
Albert Frazer
Home Decor Products, Inc
www.hdpi.com
732-593-3637 (office)
732-570-4465 (cell)
-----Original Message-----
From: Stephen Davey
[mailto:mssqldba-ezmlmshield-x83854407.[Email address protected]
Sent: Wednesday, September 26, 2007 11:48 AM
To: LazyDBA Discussion
Subject: RE: jobs managing
Albert,
Create DTS job on serverA with consecutive steps to complete tasks
through Copy Zip file to serverD. After that, create three parallel
streams, one for each server B - D, beginning with Unzip File and
continuing through Restore DB. Attach a conditional workflow "ON
Success" from Copy Zip to Server D to the first Unzip File step in each
of the three server streams. Attach appropriate workflows to control
job to completion of each stream. You should get a job flow that looks
like a three tined pitchfork!
I haven't tried this, just an idea.
S. Davey (9/26)
MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )
>>> "Albert Frazer "
<mssqldba-ezmlmshield-x99630414.[Email address protected] 09/26/07
9:49 AM >>>
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 @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
---------------------------------------------------------------------
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