How To
How to view SQL Server Agent error log (Enterprise Manager)
To view SQL Server Agent error log
- Expand a server group, and then expand a server.
- Expand Management, right-click SQL Server Agent, and then click Display Error Log.
- In the Type list, click a type of logged item to filter the log contents.
- Optionally, in the Containing text box, enter message text to filter the log contents.
- Click Apply Filter if you have selected filter parameters.
- Under Filtered contents, view the log contents.