Chapter 18. SQL Server Scheduling and Notification

by Paul Jensen


  • 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.

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features