0

I've set up a Central Management Server on a SQL Server 2016 instance. I'm able to manually run queries against multiple servers, but I want to be able to run automated maintenance scripts.

Is there a way to set up a single SQL Job that will run a script against ALL registered servers?

1 Answer 1

2

There is a separate way to control multi server jobs as described in the following link. It is a shame that these were never integrated together by MS

https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-sql-server-agent-master-job?view=sql-server-ver15

1
  • 1
    I agree Stephen. There are bits and pieces for multi-server handling but nothing that ties them together. Apr 1, 2021 at 18:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.