Tuesday, April 9, 2019

MSSQL: SQL Server Job Agent detail.

SQL Server job agent has a limitation in reporting job steps error messages. First, it only maintains up to 9 most recent error events and detail trace do not get written to it.

https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-error-log?view=sql-server-2017


In order to get more complete details, the errors need to be directed to a specific file. How to configure the error to be direct to a file will be shown here. This can be confusing to get to.



SQL Server Agent 
|-----Jobs
       |-----Name of the job (Right Click)
               |-----Properties
                         |-----Steps
                                 |-----New
                                        |-----Advanced page

                               [This where the user can allocate a file to store the errors in detail.]





             





The errors logged to the StoreJobFailureDetails will be very verbose.








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