Friday, April 12, 2019

MSSQL: Enable and Disable SQL Server Agent log


Something to watch out on "SQLAGENT.OUT" log if it gets too large. It is disabled (unchecked) by default. Enabling this, it will log all the job execution traces to SQLAGENT.OUT and may grow rapidly. 


Here is where to locate the "Include execution trace messages" feature.




The Include execution trace messages can be turned On or Off without restarting the agent.

No comments:

Post a Comment

MSSQL: Getting more detail information for failed jobs.

Often when a job failed, it provides trivial information for diagnostic. In order to expand the detail of the failed job, it can be done th...