Converting time and duration

• HelpMeInOhio

  Hall of Fame

  Points: 3945

  More actions

  August 9, 2004 at 11:24 am

  #86217

  How do I convert SysJobHistory to time and duration to meaningful numbers?

   

  select nsj.name, nsjs.step_name, nsjs.run_date, nsjs.run_duration

    from msdb..sysjobs nsj join msdb..sysjobhistory nsjs on nsj.job_id = nsjs.job_id

  where name in ('Job Name') and nsjs.step_name not in ('(Job outcome)')

  and run_date > 'YYYYMMDD' and run_duration > 100

  order by step_name, run_date desc

   

• Subhobroto Nath

  SSC Enthusiast

  Points: 117

  More actions

  August 9, 2004 at 12:58 pm

  #518244

  does

  convert ( datetime, convert( varchar(8), nsjs.run_date) , 12)

  this help?

  Also run duration is in HHMMSS ie 125 means 1 Min 25 sec