Currently, I am transitioning a server from a company to another.
They want to keep SQL Server installed on the server so we are wiping clean all the databases, maintenance plans and jobs.
I'm trying to delete a bunch of SQL Server Agent jobs but even though they are disabled they are still on "IDLE" mode so it raises me the following error when trying to delete them:
Drop failed for Job
An exception occurred while executing a Transact-SQL statement or batch. (
DELETEstatement conflicted with the
FK_subplan_job_id. The conflict occurred in database "msdb", table
The statement has been terminated. (Microsoft SQL Server, Error: 547)
How can I remove the IDLE status from the job so the delete gets through?