??SQL Server???????????????
???????????? ???????[ 2013/2/4 14:02:20 ] ????????
??????????????????????????????????SQLServer??????????????洢??SQLServer5?????????master/msdb/model/tempdb/resources???е?MSDB?У?????????????????????к????????????????????msdb???С??????????????????????????????????β??????????????????г?????????
???????DBA????????????????????·????????????????????????????????β????????????????????????????????????????????????????ν??δ??????????????
?????????е????????????msdb.dbo.sysjobhistory?С???????????????棬?????????е??????????е????棬???????????????????????????????????????????????????????sysjobs???
SELECT j.name AS 'JobName' ??
run_date ??
run_time
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobhistory h ON j.job_id = h.job_id
WHERE j.enabled = 1 --Only Enabled Jobs
ORDER BY JobName ??
run_date ??
run_time DESC
??????????????????????μ?????
???????????run_date???У??????????????????YYYYMMDD?????????????????????е???????run_time???????????Run_time?е?180002??ζ???18:00:02??С???Щ?????????????????????DBA?????????????????????????????????????????????????????????????????????δ???????????
????MSDB.dbo.agent_datetime(run_date??run_time)
?????????????????????????????????ú??????????????????δ????????????????????????????????????????????????????
SELECT j.name AS 'JobName' ??
run_date ??
run_time ??
msdb.dbo.agent_datetime(run_date?? run_time) AS 'RunDateTime'
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobhistory h ON j.job_id = h.job_id
WHERE j.enabled = 1 --Only Enabled Jobs
ORDER BY JobName ??
RunDateTime DESC
????????????????????????
??????
![](/images/ad-banner/ad-banner.png)
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11