Chapter 18. SQL Server Scheduling and Notification

by Paul Jensen

IN THIS CHAPTER

• SQL Agent Overview

• Configuring SQL Server Agent

• Viewing the SQL Server Agent Error Log

• Operators

• Jobs

• Alerts

• Scripting Jobs and Alerts

• Multiserver Job Management

• Event Forwarding

The ability to easily schedule tasks and send notification regarding the outcome of the task is one of SQL Server's most powerful administrative features. This chapter looks at the "quarterback" of this operation, the SQL Server Agent, and the trinity of jobs, alerts, and operators that work together to automate scheduling and notification.