Как сделать хранимую процедуру для мониторинга заданий в MSSQL через prtg.
Хранимая процедура
USE [msdb] GO /****** Object: StoredProcedure [dbo].[alertjob_test] Script Date: 04/25/2018 08:59:24 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[alertjob_test] zakupki NVARCHAR(max) AS BEGIN set nocount ON DECLARE @job_id VARCHAR(50) SET @job_id = (SELECT job_id FROM msdb.dbo.sysjobs WHERE [name] = zakupki) IF (not object_id('tempdb..#x') is null) drop table #x SELECT TOP 2 s.instance_id INTO #x FROM msdb.dbo.sysjobhistory s WHERE s.job_id = @job_id AND s.step_name LIKE '(Job outcome)' ORDER BY s.instance_id DESC IF EXISTS (SELECT * FROM msdb.dbo.sysjobs WHERE [name] = zakupki) BEGIN IF (not object_id('tempdb..#z') is null) drop table #z SELECT ja.job_id, j.name as job_name,… Читать далее