Delete Unused Agent Schedules
Have you ever taken a step back and looked at the enormous barrage of unused SQL Server Agent Job Schedules which have accumulated over the years on your aging SQL Server? Well, there's a solution and it not that hard!
--DELETE FROM
SELECT * FROM
dbo.sysschedules
WHERE
schedule_id NOT IN (SELECT sjs.schedule_id FROM dbo.sysjobschedules AS sjs)