April 23, 2013 at 8:20 am
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
April 25, 2013 at 9:02 am
It does not appear many people are using this feature.
April 25, 2013 at 2:56 pm
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.
May 10, 2013 at 7:19 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply