SQL 获取某个作业的最近一次执行时间

SELECT 
    J.name AS JobName,    
    CASE WHEN SJ.last_run_time = 0 THEN NULL
    ELSE 
        STUFF(STUFF(RIGHT('000000' + CAST(SJ.last_run_time AS VARCHAR(6)), 6), 3, 0, ':'), 6, 0, ':')
    END AS NextRunTime,
    CASE WHEN J.enabled = 1 THEN 'Enabled' ELSE 'Disabled' END AS JobStatus
FROM msdb..sysjobs J
INNER JOIN msdb..sysjobservers SJ ON J.job_id = SJ.job_id
WHERE J.name = @jobName