locked
sp_delete_job - could not find stored procedure RRS feed

  • Question

  • I am trying to selete a job in sql 2012

    sp_delete_job "A2E1A40D-38DB-427A-A8D6-076BFCA8FAD9"

    but keep getting error

    Could not find stored procedure 'sp+_delte_job'.

    any ideas?

    Monday, September 8, 2014 8:18 PM

Answers

All replies

  • You can possibly try to fully qualify the proc:

    EXEC msdb.dbo.sp_delete_job "A2E1A40D-38DB-427A-A8D6-076BFCA8FAD9"


    David Dye My Blog

    Monday, September 8, 2014 8:23 PM
  • Can you browse msdb database and see this PROC once?

    I suspect someone might have deleted the proc, script it from other instance and re-create it in msdb database.

    --Prashanth

    Monday, September 8, 2014 8:24 PM