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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
