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

How to Install SQL Server 2000

How To

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. Expand a server group, and then expand a server.

  2. Expand Management, right-click SQL Server Agent, and then click Properties.

  3. Under Error log, select the Include execution trace messages check box.

    Because this option can cause the error log to become large, set it only when investigating a specific SQL Server Agent problem.