1. Home
  2. SQL
  3. Microsoft SQL Server 2000

Viewing the SQL Server Agent Error Log

The SQL Server Agent maintains an error log that records information, warnings, and error messages concerning its operation. This error log is useful when debugging Agent-dependent operations, such as jobs. To access the error log, right-click the SQL Server Agent folder in Enterprise Manager and select Display Error Log. You can filter the errors by type and search for errors containing specific text.



    		Part I: Welcome to Microsoft SQL Server
    		Part II: SQL Server Tools and Utilities
    		Part III: SQL Server Administration
    		Chapter 8. Installing and Upgrading SQL Server
    		Chapter 9. Client Installation and Configuration
    		Chapter 10. SQL Server System and Database Administration
    		Chapter 11. Creating and Managing Databases
    		Chapter 12. Creating and Managing Tables in SQL Server
    		Chapter 13. Creating and Managing Indexes
    		Chapter 14. Implementing Data Integrity
    		Chapter 15. Security and User Administration
    		Chapter 16. Database Backup and Restore
    		Chapter 17. Database Maintenance
    		Chapter 18. SQL Server Scheduling and Notification
    		SQL Agent Overview
    		Configuring SQL Server Agent
    		Viewing the SQL Server Agent Error Log
    		Operators
    		Jobs
    		Alerts
    		Scripting Jobs and Alerts
    		Multiserver Job Management
    		Event Forwarding
    		Summary
    		Chapter 19. Managing Linked and Remote Servers
    		Chapter 20. Importing and Exporting SQL Server Data Using BCP and DTS
    		Chapter 21. Administering Very Large SQL Server Databases
    		Chapter 22. Data Replication
    		Chapter 23. SQL Mail
    		Chapter 24. SQL Server Clustering
    		Chapter 25. Defining System Administration and Naming Standards
    		Part IV: Transact-SQL
    		Part V: SQL Server Internals and Performance Tuning
    		Part VI: Additional SQL Server Features