Export (0) Print
Expand All

Monitoring the Environment

SQL Server 2000

SQL Server Agent monitors itself and the Microsoft® SQL Server™ service.


SQL Server Agent starts the xp_sqlagent_monitor extended stored procedure (SQL Server Agent Monitor) to monitor the SQLServerAgent service to ensure that it is available to execute scheduled jobs, raise alerts, and notify operators. If the SQLServerAgent service terminates unexpectedly, the SQL Server Agent Monitor restarts the service.

Restarting the SQL Server Service

SQL Server Agent can restart the local instance of SQL Server if it has terminated for reasons other than a typical shutdown. Automatic restart is enabled by default. SQL Server Agent restarts the instance of SQL Server when it detects abnormal termination. This allows an alert to be set on this event.

Note  If you are using SQL Server 2000 failover clustering, you must ensure auto-restart is disabled in order for failover clustering to work.

To set job execution shutdown

Enterprise Manager

To autostart SQL Server Agent Monitor

Enterprise Manager


To send SQL Server Agent error messages

Enterprise Manager

To view SQL Server Agent error log

Enterprise Manager

To rename a SQL Server Agent error log

Enterprise Manager

To view a master SQL Server Agent error log

Enterprise Manager

See Also

StopMonitor Method

© 2014 Microsoft