Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multi-server Administration - Execute in master Expand / Collapse
Author
Message
Posted Tuesday, April 23, 2013 8:20 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 2, 2014 12:29 PM
Points: 229, Visits: 251
Dear experts,

I have implemented a multi-server environment. There is one master server (MSX) and three target servers (TSX).
But I have a job that I want to execute in all four servers, either in the targets and in the master. Is there a way to do it?

Obvisously I know that I can create a job in the Local Jobs, but then there will be two different jobs.

Thanks in advance,


________________
DBA Cabuloso
Lucas Benevides
Post #1445457
Posted Thursday, April 25, 2013 9:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 6:21 PM
Points: 136, Visits: 137
It does not appear many people are using this feature.
Post #1446552
Posted Thursday, April 25, 2013 2:56 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 282, Visits: 889
I run most of my maintenance and monitoring from a central server (one id DEV, one in TEST and one in PROD).
I use powershell scripts scheduled via SQL agent jobs.

Most of them start by getting a list of servers against which to run maintenance tasks.
Post #1446724
Posted Friday, May 10, 2013 7:19 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 31, 2014 2:38 PM
Points: 27, Visits: 469
I've been using multi-server administration on ~40 instances for almost 2 years, and it's fantastic. As far as I know a job can target the local server OR multiple servers, but not both. Small price to pay for the convenience though.. having 2 (almost identical) versions of each job wasn't a dealbreaker for me.
Post #1451576
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse