Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
set nocount on; select distinct replace (j.name, ' ', '') +'|'+ case h.run_status when 0 then 'Failed' when 1 then 'Successful' when 3 then 'Cancelled' when 4 then 'In Progress' end as JobStatus from msdb..sysjobhistory h, msdb..sysjobs j where j.job_id = h.job_id and h.step_id = 1 and h.run_date = (select max(hi.run_date) from msdb..sysjobhistory hi where h.job_id = hi.job_id) and h.run_time = (select max(hj.run_time) from msdb..sysjobhistory hj where h.job_id = hj.job_id) order by 1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL - Subquery in WHERE section||4||33|
|How do i delete the last node in an xml in T-SQL||7||27|
|SQL Server Reports (SSRS 2014) - Reports Timing Out||11||116|
|Section based report in SSRS||14||33|
Join the community of 500,000 technology professionals and ask your questions.