SQL Server 2008 JOB查看

最新推荐文章于 2019-10-26 18:00:50 发布

cmn33423

最新推荐文章于 2019-10-26 18:00:50 发布

阅读量215

点赞数

文章标签：数据库

use msdb
go
SELECT
   j.[name] AS [JobName],
   run_status = CASE h.run_status
   WHEN 0 THEN 'Failed'
   WHEN 1 THEN 'Succeeded'
   WHEN 2 THEN 'Retry'
   WHEN 3 THEN 'Canceled'
   WHEN 4 THEN 'In progress'
   END,
   h.run_date AS LastRunDate,
   h.run_time AS LastRunTime
FROM msdb.dbo.sysjobhistory h
   INNER JOIN msdb.dbo.sysjobs j ON h.job_id = j.job_id
       WHERE j.enabled = 1
       AND h.instance_id IN
       (SELECT MAX(h.instance_id)
           FROM msdb.dbo.sysjobhistory h GROUP BY (h.job_id))

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20630340/viewspace-761875/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20630340/viewspace-761875/