How to view SQL Server Agent error log (Enterprise Manager)
To view SQL Server Agent error log
- Right-click SQL Server Agent; then click Display Error Log.
- In the SQL Server Agent Error Log dialog box, in the Type list, optionally click a type of logged item to filter the log contents.
- In the Containing text box, optionally enter message text to filter the log contents.
- Click Apply Filter if you have selected filter parameters.
- Under Filtered contents, view the log contents.
(c) 1988-98 Microsoft Corporation. All Rights Reserved.