SQLServerAgent Service

SQL Server Agent supports features allowing the scheduling of periodic activities on Microsoft® SQL Server™, or the notification to system administrators of problems that have occurred with the server. The SQL Server Agent components that implement this capability are:

Here are the primary components used in the definition and operation of jobs, alerts, and operators.

SQL Server version 7.0 is more highly automated than earlier versions of SQL Server, and does a better job of configuring itself automatically to meet processing demands. These features lower the potential for exception conditions that would trigger alerts. Scheduled jobs remain a good feature for implementing recurring tasks such as backup procedures.

See Also

Automating Administrative Tasks

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.