I have a failed job which is logged in SQL Server Logs but not logged in SQL Server Agent Error Logs. The job is executed as user: NT SERVICE\SQLSERVERAGENT. Limit size of job history and Remove agent history boxes are unchecked in properties of SQL Server Agent. Here are the results of SQL Server Logs:

enter image description here

When it comes to SQL Server Agent Error Logs, it does not contain any information about this failure. I thought that if a job fails then it should be necessarily logged into SQL Server Agent Error Logs. Why this happens?

  • Is the error contained in the Job Step history for the failed execution?
    – Rich
    Oct 25, 2019 at 7:44
  • Yes. I can see it in job step history Oct 25, 2019 at 7:47


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.