??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

????????????????????????