We need to perform the below steps to delete the jobs or maintenance plans in such cases from sysmaintplan_log table or fromsysmaintplan_subplans table .
Step 1:
Execute the below query to obtain the Maintenance plan name and Id SELECT NAME, ID FROM MSDB..SYSMAINTPLAN_PLANS
Step 2:
Replace the Id obtained from Step 1 into the below query and delete the entry from log tableDELETE FROM SYSMAINTPLAN_LOG WHERE PLAN_ID=' '
Step 3:
Replace the Id obtained from Step 1 into the below query and delete the entry from subplans table as shown below,DELETE FROM SYSMAINTPLAN_SUBPLANS WHERE PLAN_ID = ' '
Step 4:
Finally delete the maintenance plan using the below query where ID is obtained from Step1DELETE FROM SYSMAINTPLAN_PLANS WHERE ID = ' '
Step 5:
Check and delete the jobs from SSMS if it exists.
Execute the below query to obtain the Maintenance plan name and Id SELECT NAME, ID FROM MSDB..SYSMAINTPLAN_PLANS
Step 2:
Replace the Id obtained from Step 1 into the below query and delete the entry from log tableDELETE FROM SYSMAINTPLAN_LOG WHERE PLAN_ID=' '
Step 3:
Replace the Id obtained from Step 1 into the below query and delete the entry from subplans table as shown below,DELETE FROM SYSMAINTPLAN_SUBPLANS WHERE PLAN_ID = ' '
Step 4:
Finally delete the maintenance plan using the below query where ID is obtained from Step1DELETE FROM SYSMAINTPLAN_PLANS WHERE ID = ' '
Step 5:
Check and delete the jobs from SSMS if it exists.
Many thanks to kapil