1

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?

Improve this question
2
  • 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
    – Rauf Asadov
    Oct 25, 2019 at 7:47

0

Reset to default

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.