1

After deleting a SQL Server Agent job I continue to get notifications that the job attempted to run and failed. I am receiving the following error message.

[000] Unable to retrieve steps for job my_job
[298] SQLServer Error: 14262, The specified @job_id ('CC65FEFB-0033-442E-B55E-6209E25C5039') does not exist. [SQLSTATE 42000]

I have checked the following tables in the msdb database and none of them have the specified job_id except the dbo.sysjobhistory table.

  • dbo.sysjobs
  • dbo.sysjobschedules
  • dbo.sysjobsteps
  • dbo.sysjobstepslogs
  • dbo.sysjobservers
  • dbo.sysjobactivity
  • dbo.sysjobhistory

Is there anywhere else I can look?
Also, today I have stopped and restarted the SQL Server Agent and will update this post tomorrow with the result.

Thank you in advance!

  • 3
    Start a trace for calls to sp_start_job - you should catch the offender pretty quickly. – Aaron Bertrand Oct 9 '13 at 20:10
  • Additional information being requested on twitter so I thought I would add it here. Q: "anything in codebase/schedule task calling sp_start_job?" A: No – KenWilson Oct 9 '13 at 20:11
  • @AaronBertrand I will set that up tonight! Thanks. – KenWilson Oct 9 '13 at 20:12
  • How about sp_delete_job @job_id = ? Also, any replication involved ? – Kin Shah Oct 9 '13 at 20:13
  • Additional information being requested on twitter. Q:"what build of SQL Server?" A:"SQL Server 2008 R2 SP1 (10.50.2425)" – KenWilson Oct 9 '13 at 20:13
0

A stop and start of the SQL Agent fixed the issue.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.