Do More With Less: Inside SQL Agent Multi-Server Administration
Enterprise Database Administration & Deployment
One of the of the most under-utilized management features of SQL Server is SQL Agent Multi-Server Administration, which allows you to create a SQL Agent job on one server and then deploy it to multiple servers instantly. This allows you to have consistency with your SQL Agent jobs by managing them in a single location. You’ll learn about the benefits, drawbacks, workarounds, and underlying objects behind this technology. You’ll discover how to monitor job execution status and handle the security implications of the master-target relationship. SQL Server MVP Mike Hillwig will show you how to to deploy this simple, yet powerful feature right out of the box without writing a single line of additional code.
Basic understanding of the SQL Agent
No material found.