Situatie
Mai jos este un script ce listeaza toate joburile ce nu s-au executat cu succes pe un server MSSQL in ultimele 30 de zile.
Solutie
SELECT
sj.name
,sjs.step_id
,sjs.step_name
,CASE sjh.run_status
WHEN 0 THEN ‘Failed’
WHEN 2 THEN ‘Retried’
WHEN 3 THEN ‘Cancelled’
END RunStatus
,sjh.run_date
, sjh.run_duration
,sjh.message
FROM msdb.dbo.sysjobs sj
INNER JOIN msdb.dbo.sysjobsteps sjs ON sj.job_id = sjs.job_id
INNER JOIN msdb.dbo.sysjobhistory sjh ON sjs.job_id = sjh.job_id AND sjs.step_id = sjh.step_id
WHERE
sjh.run_status <> 1
AND
convert(date,convert(varchar(max),sjh.run_date)) > DATEADD(DAY, -30, SYSDATETIME())
order by 1
Leave A Comment?