14.2. Create and Configure Automation Objects

The SQL Server Agent service manages many different objects on the server, each one responsible for its own function in the larger automation infrastructure. Mastering these objects is critical to effectively implementing an automation plan. In the following sections, we will look at the most important of these objects, specifically proxies, schedules, operators, alerts, and jobs. Finally, we will look at how you can simplify the process of creating a basic maintenance automation implementation by using the SQL Server Maintenance Plan Wizard.

14.2.1. Create and Configure Proxies

Although most of the processing that a SQL Server Agent automation structure will perform will be directed to SQL Server ...

Get SQL Server® 2008 Administration: Instant Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.