Job Question

HI,
I have multiple SQL servers and i am planning to create a job and deploy to
all the servers instead of deploying that job one by one in all servers and
generate report from one server instead of all (consolidation) later to see
on which server the job has failed. What best options do i have to link all
of them together? SO far i have known of linked server and making master and
target server. Anything else? or which one is better bewteen this two?
TIA
Rupart,
I would prefer using a master server and several target servers in this
scenario. The job status can be viewed locally on the target server or
remotely on the master server. Note, the job definition cannot be changed
on the target server. Also note that a target server (to my knowledge) can
only be associated with one master server at a time.
HTH
Jerry
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:F6C965C6-D4A8-4697-B482-7D37C0BCE9F7@.microsoft.com...
> HI,
> I have multiple SQL servers and i am planning to create a job and deploy
> to
> all the servers instead of deploying that job one by one in all servers
> and
> generate report from one server instead of all (consolidation) later to
> see
> on which server the job has failed. What best options do i have to link
> all
> of them together? SO far i have known of linked server and making master
> and
> target server. Anything else? or which one is better bewteen this two?
> TIA