Сенсор для prtg. Сенсор для задания sql
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
