Summary
The following are the key points to keep in mind when you want to automate database administration tasks.
SQL Server Agent must be running so that alerts and jobs can be processed.
Use the Job Scheduler to automate common DBA jobs such as backing up a database, backing up a transaction log, running DBCC commands, and importing/exporting data.
Jobs can contain one or more steps and can have step dependencies.
Jobs can contain Transact-SQL commands, VBScript, JScript, and scripts built in other languages.
Jobs can execute external .BAT, .EXE, and .CMD files.
Use the Alert Manager to automatically notify an operator of problems, such as a database errors or user-defined error messages.
The Job Scheduler, Alert Manager, and Database Maintenance ...
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.
