Using the scheduling engine, you can schedule and automate command executions, Transact-SQL statements, and replication tasks. Using the alerts management interface, you can set up SQL Enterprise Manager to automatically respond to SQL Server events by executing a predefined task or sending an alert or a page to selected users. Using SQLMail, you can send messages through the built-in mail application programming interface (MAPI) client interface in Windows NT. These messages can consist of short text strings, the output from a query, or an attached file. Using SQL Performance Monitor, SQL Enterprise Workbench, and the sp_monitor system stored procedure, you can monitor server activity and performance. The chapters in this part explain how.
Chapter 16, Scheduling Tasks, explains how to use SQL Enterprise Manager to schedule various server tasks for execution at specified times. You can schedule command executions, Transact-SQL statements, or replication tasks. A task can be scheduled to occur at a single specified time, on a recurring schedule, or on demand.
Chapter 17, Managing Alerts, shows you how to set up SQL Server to respond to errors by executing a task that you have defined or by sending an email or a pager message to an operator.
Chapter 18, Setting Up Mail, shows you how to set up SQL Server as a mail client, so that it can send mail messages through the built-in mail application programming interface (MAPI) client interface in Windows NT.
Chapter 19, Monitoring Server Activity and Performance, shows you how to monitor SQL Serveractivity and performance using SQL Performance Monitor and SQL Enterprise Manager. It also explains how to use the sp_monitor system stored procedure to obtain SQL Serverstatistics.