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

To view SQL Server Agent error log

  1. Right-click SQL Server Agent; then click Display Error Log.
  2. 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.
  3. In the Containing text box, optionally enter message text to filter the log contents.
  4. Click Apply Filter if you have selected filter parameters.
  5. Under Filtered contents, view the log contents.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.