我需要监视维护计划如果仍在运行,我发现了一个旧帖子(感谢don sql server maintenance plan history check for success or failure)来查询日志并获取作业结果,但这只会在完成后给出结果:
SELECT
mp.name AS [MTX Plan Name],
msp.subplan_name AS [Sub Plan Name],
mpl.start_time AS [JobStart],
mpl.end_time AS [JobEnd],
mpl.succeeded AS [JobSucceeded]
FROM
msdb.dbo.sysmaintplan_plans mp
INNER JOIN msdb.dbo.sysmaintplan_subplans msp ON mp.id = msp.plan_id
INNER JOIN msdb.dbo.sysmaintplan_log mpl ON msp.subplan_id = mpl.subplan_id
AND mpl.task_detail_id = -- Get the most recent run for this database
(SELECT TOP 1 ld.task_detail_id
FROM msdb.dbo.sysmaintplan_logdetail ld
WHERE ld.command LIKE ('%['+db_name()+']%')
ORDER BY ld.start_time DESC)
1条答案
按热度按时间hfyxw5xn1#
此查询将为您提供与维护计划相关的活动/正在运行的作业。不管那里有什么意味着它现在正在运行
如果您需要与prtg集成方面的帮助,请告诉我