Cannot Delete a SQL job.

Question

Hi, I have disabled log shipping on a SQL 2005 database and deleted the log shipping DB on the secondary server. However i cannot delete the LSRestore_DB___ job, either by T-SQL (sp_delete_log_shipping_primary_secondary, sp_delete_job) or using the management studio on the secondary server. It just wont go. The query keeps on executing for a good 7 hours. Tried disabling, still doesn't delete. Restarted the server too. Also tried the Can anyone help me delete this SQL job please ? Many Thanks

Answer 1

Have your tried setting the allow editing of system tables, and going directly into the system table that holds the job information and tried deleting the row from there?

Make sure to be extra careful when doing this, not recommended, but sometimes direct editing to the system tables needs to be done.