Complete a Server Assessment – Jobs using Each Schedule

Below you will find the code to get the jobs that are using each schedule.  Simply select the text and copy to the Clipboard.

SELECT AS ‘ScheduleName’
, SUSER_NAME(s.owner_sid) AS ‘ScheduleOwner’
FROM msdb.dbo.sysschedules s
INNER JOIN msdb.dbo.sysjobschedules c
ON S.Schedule_ID = c.schedule_id
INNER JOIN msdb.dbo.sysjobs j
ON c.job_id = j.job_id

This code was written using the Microsoft SQL Server documentation.  If you find that this code was copied from else where, please let me know so I can give proper credit.