select 
	j.name,
    j.enabled,
	case freq_type
		when 1    then 'Once'
		when 4    then 'Daily'
		when 8    then 'Weekly on '
			+    case freq_interval & 2 when 2 then 'M' else '' end 
			+    case freq_interval & 4 when 4 then 'Tu' else '' end
			+    case freq_interval & 8 when 8 then 'W' else '' end 
			+    case freq_interval & 16 when 16 then 'Th' else '' end
			+    case freq_interval & 32 when 32 then 'F' else '' end
			+    case freq_interval & 64 when 64 then 'Sa' else '' end
			+    case freq_interval & 1 when 1 then 'Su' else '' end
		when 16   then 'Monthly on day ' + convert(varchar(2), freq_interval)
		when 32   then 'Monthly '
			+ case freq_relative_interval 
				when 1 then 'Every First '
				when 2 then 'Every Second '
				when 4 then 'Every Third '
				when 8 then 'Every Fourth '
				when 16 then 'Every Last '
			end
			+ case freq_interval	
				when 1 then 'Sunday' 
				when 2 then 'Monday'
				when 3 then 'Tuesday' 
				when 4 then 'Wednesday' 
				when 5 then 'Thursday' 
				when 6 then 'Friday' 
				when 7 then 'Saturday' 
				when 8 then 'Day' 
				when 9 then 'Week day'
				when 10 then 'Weekend day'
			end	
		when 64   then 'Startup'
		when 128 then 'Idle'
		else 'Error'
	end as 'Schedule',	

	-- Job sub-frequency
	case freq_subday_type
		when 1    then 'one time'
		when 2    then 'every ' + convert(varchar(3), freq_subday_interval) + ' seconds'
		when 4    then 'every ' + convert(varchar(3), freq_subday_interval) + ' minutes'
		when 8    then 'every ' + convert(varchar(3), freq_subday_interval) + ' hours'
	end as 'Frequency',

	-- Job start time
	substring (right (stuff (' ', 1, 1, '000000') + convert(varchar(6),active_start_time), 6), 1, 2) +  ':' +
	substring (right (stuff (' ', 1, 1, '000000') + convert(varchar(6), active_start_time), 6) ,3 ,2) + ':' +
	substring (right (stuff (' ', 1, 1, '000000') + convert(varchar(6),active_start_time), 6) ,5 ,2) as 'Start',

	-- Job end time
	case freq_subday_type
		when 1  then NULL
		else substring (right (stuff (' ', 1, 1, '000000') + convert(varchar(6), active_end_time), 6), 1, 2) +  ':' +
				substring (right (stuff (' ', 1, 1, '000000') + convert(varchar(6), active_end_time), 6) ,3 ,2)	+ ':' +
				substring (right (stuff (' ', 1, 1, '000000') + convert(varchar(6), active_end_time), 6) ,5 ,2) 
	end as 'End'

from msdb.dbo.sysjobs j join msdb.dbo.sysjobschedules s on j.job_id = s.job_id 
join msdb.dbo.sysschedules h on s.schedule_id = h.schedule_id
order by j.name