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
MS Sql Server LazyDBA home page