Work with SQL Server Agent jobs

Microsoft SQL Server features a powerful and flexible job-scheduling engine called SQL Server Agent. This sample chapter from MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005—Implementation and Maintenance explains:

• How to use SQL Server Agent to define jobs and schedule them to automatically execute on a scheduled basis
• How to create maintenance plans to specify maintenance tasks such as backups to be performed against one or more databases
• How to define operators to send messages about job success or failure
• How to configure alerts, which enable you to monitor the system for specified conditions and execute jobs to proactively address potential issues

The chapter concludes with review and practice suggestions, including a real-world case scenario to reinforce and apply the lessons covered.

Title: MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005—Implementation and Maintenance
ISBN: 073562271X
Published: May 2006
Author: Solid Quality Learning
Chapter: Chapter 14: Working with SQL Server Agent Jobs
Published by Microsoft Press