/************************************************************
* * k.moskvichev ©
* Time: 10.12.2015 14:07:36
************************************************************/
USE msdb
SELECT
DISTINCT
TOP 100
--a.job_id AS Id
a.name AS NAME_job
,MAX(b.run_date),
max(b.run_time)
-- b.step_id,
--,b.run_status
--SELECT *
FROM
dbo.sysjobs a
FULL OUTER JOIN
dbo.sysjobhistory b
ON a.job_id = b.job_id
AND
a.[enabled] = '1'
--WHERE
GROUP BY
--b.run_date,
a.job_id
,a.name --a.job_id,a.name,b.step_id,b.run_status
ORDER BY
a.name DESC
-- b.run_time DESC
select * FROM [msdb].[dbo].[sysjobs]
Similar Posts: