Do More With Less: Inside SQL Agent Multi-Server Administration

Speaker: Mike Hillwig

Duration: 60 minutes

Track: 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.

Accompanying Material

No material found.

Back to Top cage-aids