How to view SQL Server Agent error log (Enterprise Manager)

How to Install SQL Server 2000

How To

How to view SQL Server Agent error log (Enterprise Manager)

To view SQL Server Agent error log

  1. Expand a server group, and then expand a server.

  2. Expand Management, right-click SQL Server Agent, and then click Display Error Log.

  3. In the Type list, click a type of logged item to filter the log contents.

  4. Optionally, in the Containing text box, enter message text to filter the log contents.

  5. Click Apply Filter if you have selected filter parameters.

  6. Under Filtered contents, view the log contents.