Home Forums SQL Server 2005 T-SQL (SS2K5) DBO.SysJobHistory, how do you get the Job Time? RE: DBO.SysJobHistory, how do you get the Job Time?

  • May 1, 2012 at 10:15 am

    #1481900

    dwilliscp (5/1/2012)

    In the MSDB MS is storing the information about a SQL Job, and in the DBO.SysJobHistory it has a column called "run_time".. Using SQL how do you convert this field to get the time the job ran?

    Are you asking at what time the job ran or how long the job (or job step) ran?