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.

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.