We have a sql server agent job which runs every day on sql server 2008R2. The job has been running for years and had no issues before; and nothing has been changed recently.
Two weeks ago, the job started sending a failed job email once every 2 or 3 days. It also logs a failed job status both on sql server agent job history as well as event viewer. However, the job is successfully executed because we are getting a successful report from the application side all the time. Can someone have any idea how to fix this issue?