• prefix the job(s) you want to delete with xxx (i.e., xxxFullDatabaseBackups)

    --NOTE: uncomment the delete part and comment out the select after you make sure the select --statement returns the correct records you want to delete.

    --*SCRIPT*--

    --delete sysmaintplan_subplans

    select *

    FROM sysmaintplan_subplans AS subplans INNER JOIN

    sysjobs_view AS syjobs ON subplans.job_id = syjobs.job_id

    WHERE (syjobs.name like '%xxx%')

    --GO INTO SQL AGENT AND RIGHT CLICK TO DELETE THOSE JOBS MANUALLY...