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!

8
  • 3
    Start a trace for calls to sp_start_job - you should catch the offender pretty quickly. Oct 9, 2013 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, 2013 at 20:11
  • @AaronBertrand I will set that up tonight! Thanks.
    – KenWilson
    Oct 9, 2013 at 20:12
  • How about sp_delete_job @job_id = ? Also, any replication involved ?
    – Kin Shah
    Oct 9, 2013 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, 2013 at 20:13

1 Answer 1

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 and acknowledge you have read our privacy policy.

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