How to write execution trace messages to the SQL Server Agent error log (Enterprise Manager)

To write execution trace messages to the SQL Server Agent error log

  1. Right-click SQL Server Agent; then click Properties.
  2. In the SQL Server Agent Properties dialog box, on the General tab, under Error log, select Include execution trace messages. Set this option only when investigating a specific SQL Server Agent problem because it can cause the error log to become large.

  


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