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 III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features