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
- Right-click SQL Server Agent; then click Properties.
- 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.