Chapter 16. SQL Server Scheduling and Notification

Automation is the key to efficiency, and the SQL Server Agent is your automation tool in SQL Server 2008. This chapter delves into the administrative capabilities of the SQL Server Agent and its capability to schedule server activity and respond to server events.

The SQL Server Agent, which runs as a Windows service, is responsible for running scheduled tasks, notifying operators of events, and responding ...

Get Microsoft® SQL Server 2008 R2 Unleashed 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.