Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @Date datetime
- SET @Date = DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
- SELECT j.name as [Job Name],
- h.step_name AS [Job Step Name],
- CASE j.enabled WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END AS [Enabled],
- CONVERT(CHAR(10), CAST(STR(h.run_date,8, 0) AS dateTIME), 111) as [Run Date],
- STUFF(STUFF(RIGHT('000000' + CAST ( h.run_time AS VARCHAR(6 ) ) ,6),5,0,':'),3,0,':') as [Run Time],
- STUFF(STUFF(RIGHT('000000' + CAST ( h.run_duration AS VARCHAR(6 ) ) ,6),5,0,':'),3,0,':') as [Step Duration],
- case h.run_status when 0 then 'Failed'
- when 1 then 'Succeded'
- when 2 then 'Retry'
- when 3 then 'Cancelled'
- when 4 then 'In Progress'
- end as [Execution Status],
- h.message as [Message Generated]
- FROM msdb.dbo.sysjobs j inner join msdb.dbo.sysjobhistory h
- ON j.job_id = h.job_id
- where h.run_status = 0 AND msdb.dbo.agent_datetime(h.run_date, h.run_time)> @Date AND j.name like '%MAINTENANCE - BACKUP%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement