O'Reilly logo

Expert Scripting and Automation for SQL Server DBAs by Peter A. Carter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Peter A. Carter 2016

Peter A. Carter, Expert Scripting and Automation for SQL Server DBAs, 10.1007/978-1-4842-1943-0_3

3. SQL Server Agent Multi-Server Environments

Peter A. Carter

(1)Botley, UK

SQL Server includes useful features for managing the enterprise that allow you to run queries and policies against multiple instances and run SQL Server Agent jobs on multiple instances. These features are key to your automation efforts, as they provide a mechanism for scheduling and running your scripts across the enterprise.

Using Central Management Servers

A central management server is an instance of SQL Server that has been registered as a controller that will store the connection details for groups of servers. This allows a DBA to run a query or evaluate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required