InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:40:00 GMT20http://www.sqlservercentral.com/Forums/Topic763256-146-1.aspxBelieve it or not, it's actually needs to be parsed out. For example a value of 1442 translates to MM:SS.Mon, 03 Aug 2009 07:04:07 GMTTimothy Ford-473880http://www.sqlservercentral.com/Forums/Topic763256-146-1.aspxThanks Tim - this is exactly what I need. Looks like the duration is in milliseconds. Does that sound right?Fri, 31 Jul 2009 15:30:26 GMTbsivelhttp://www.sqlservercentral.com/Forums/Topic763256-146-1.aspxThe core table for this is msdb.dbo.sysjobhistory. You can add a great deal of information by joining to other metadata tables in msdb, but this will get you started:[code]SELECT SJ.[name], SJH.[step_id], SJH.[step_name], SJH.[run_date], SJH.[run_time], SJH.[run_duration]FROM msdb.dbo.[sysjobs] SJ LEFT JOIN msdb.dbo.[sysjobhistory] SJH ON SJ.[job_id] = SJH.[job_id]ORDER BY SJ.[name], SJH.[run_date] DESC, SJH.[step_id][/code]Fri, 31 Jul 2009 11:18:09 GMTTimothy Ford-473880http://www.sqlservercentral.com/Forums/Topic763256-146-1.aspxI would like to query the durations of steps in several SQL Agent jobs and write them on a administrative report. Does anyone know how or where to get these values without view the history?thanks in advance!bsivelFri, 31 Jul 2009 10:41:05 GMTbsivel