USE [msdb]
Select c.schedule_id, c.job_id, b.[name], b.[enabled], freq_type, freq_interval,
freq_subday_type, freq_subday_interval, freq_relative_interval, freq_recurrence_factor,
active_start_date, active_end_date, active_start_time, active_end_time,
next_run_date, next_run_time, b.date_created
from sysschedules a,sysjobs b,sysjobschedules c
where b.job_id = c.job_id and a.schedule_id = c.schedule_id