select	[name]
	from	sys.sysdatabases
	where	[name] not in (
				select	database_name
                from    msdb..backupset
			)
	and		[name] not in ('tempdb','model')

select	null
	,		j.name
	,		''
	,		null
	,		null
	,		case
				when j.enabled != 1 then 'Disabled'
				else 'Never Run' 
			end as "Run Status"
	,		null	
	,		null
	,		null
	,		@@servername
	,		j.job_id
	from	msdb..sysjobs j
	where	(
				j.job_id not in (
								SELECT		h.job_id
								FROM		[msdb].[dbo].[sysjobhistory] h
								where		j.job_id = h.job_id				)
			)
	or		(j.enabled != 1)
	union
	select	cast(h2.instance_id as int)
	,		j.name
	,		h2.step_name
	,		h2.step_id
	,		h2.[message]
	,		case
				when h2.run_status = 0 then 'Failed'
				when h2.run_status = 3 then 'Cancelled'
				else 'Not listed'
			end as "Run Status"
	,		h2.run_date	
	,		h2.run_time
	,		h2.operator_id_emailed as "Operator Emailed"
	,		h2.server
	,		h2.job_id
	from	msdb..sysjobhistory h2
	join	msdb..sysjobs j on j.job_id = h2.job_id
	where	h2.instance_id in (
								SELECT		max(h.instance_id)
								FROM		[msdb].[dbo].[sysjobhistory] h
								group by	h.[job_id]
			)
	and		h2.run_status in (0,2)
	order by 7,8, j.name, 3