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 '19 at 7:44
  • Yes. I can see it in job step history – RaufDBA Oct 25 '19 at 7:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.