Thursday, July 23, 2020

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 through "Include execution trace messages"

https://docs.microsoft.com/en-us/sql/ssms/agent/write-execution-trace-messages-to-sql-server-agent-log-ssms?view=sql-server-2017

SQL Server Agent --- Right Click --- Properties





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...