SQL agent Error - Critical

[Pin2saran]

Hi ,

i have got a problem in my environment, The SQL server Agent errror logs is continously filled up with below error messages
"[298] SQLServer Error: 14262, The specified @job_id ('74AF9B09-0C54-449E-8BDC-3D323D570D1F') does not exist. [SQLSTATE 42000] (ConnExecuteCac hableOp"

After several research, i got to know that
EXEC sp_delete_job @job_id='74AF9B 09-0C54-449E-8BDC-3D323D570D1F' statement is running contionously at background , which is making these error messagges entries.
I even restarted the SQL Agent service , but still not helped.

Please guide me in resolving this problem.
thanks in advance.

[ck9663]

You might want to check first why there's a delete job running. If you are certain that it is not needed, disable that job first and see what happens.


Good Luck!!!


~~ CK

[PsychoCoder]

Read through the comments in this post, it may solve your issue.