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.



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net