Introduction

Virtually every organization can reduce administrative effort by automating common DBA tasks. SQL Server 2000 provides several tools that can help automate common tasks: Job Scheduler, Alert Manager, and Database Maintenance Plan Wizard. These tools are integrated with SQL Server Agent. Together, these tools and SQL Server Agent can automate common tasks and, when taken to the next level, can provide proactive database management.

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.