Showing posts with label Job History. Show all posts
Showing posts with label Job History. Show all posts
Wednesday, November 12, 2014
SQL Server Job Run Time from SQL Agent
How to get run time for job total run time from history.
USE MSDB;
GO
select
j.name as 'JobName',
run_date,
run_time,
CONVERT(CHAR(8),DATEADD(second,run_time,0),108) AS Total_Run_Time,
h.message
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
and j.name = 'JOB_Name_Make_Change'
order by run_date desc
Subscribe to:
Posts (Atom)