O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server Agent

SQL Server Agent is an easy-to-use and robust task scheduler and alert manager. It includes several useful features, such as history logs and the capability to email or page an operator when an event occurs.

SQL Server Agent has the following components:

  • Jobs

  • Alerts

Jobs

Jobs are typically used to schedule and automate tasks. SQL Server Agent can automate many types of jobs, including the following:

  • Backups— Automatic database backups should be an integral part of everyone's production systems. SQL Server Agent can automatically back up a database at a preset interval. See Chapter 10, “Backup and Recovery,” for more information on automatically backing up the database.

  • Scheduled database maintenance— Database maintenance commands, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required