Chapter 14. Automating with the SQL Server Agent Service
IN THIS CHAPTER, YOU WILL LEARN TO DO THE FOLLOWING:
CONFIGURE THE SQL SERVER AGENT SERVICE (Pages 456 – 469)
Understand Automation Artifacts (Page 456)
Perform Basic Service Configuration (Page 459)
Configure Database Mail (Page 465)
CREATE AND CONFIGURE AUTOMATION OBJECTS (Pages 470 – 495)
Create and Configure Proxies (Page 470)
Create and Configure Schedules (Page 473)
Create and Configure Operators (Page 477)
Create and Configure Alerts (Page 479)
Create and Configure Jobs (Page 482)
Use the SQL Server Maintenance Plan Wizard (Page 488)
The job of the database administrator (DBA) is definitely challenging, and historically it has been a reactive one. You spend your life reacting to problems ...
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.