1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
USE msdb SELECT TOP 1 /* a.job_id AS Id ,a.name AS NAME_job , b.run_date , b.run_time , b.step_id,*/ b.run_status --SELECT * FROM dbo.sysjobs a FULL OUTER JOIN dbo.sysjobhistory b ON a.job_id = b.job_id AND a.[enabled] = '1' --AND b.run_date = @@servername WHERE a.name IN ('LSRestore_s0030_ax_molniya_DB') AND b.run_status NOT IN ('4') AND b.step_id IN ('0') /*GROUP BY a.name ,a.job_id ,b.step_id ,b.run_date*/ ORDER BY b.run_date DESC, b.run_time DESC |
Настройка самого сенсора в prtg