run_time field in msdb

• timingskey

  SSCommitted

  Points: 1708

  More actions

  April 23, 2003 at 3:59 pm

  #64213

  I need to compare the run_time field in sysjobhistory to getdate(). But I cannot figure out how to convert getdate() to the right value, or vice-versa.

  Does anyone have a way to do this?

  Thanks,

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  April 23, 2003 at 5:48 pm

  #455107

  Try

  Select Top 5

  Run_Date,Run_Time,

  Convert(Int,Convert(char(8),Getdate(),112)),Convert(Int,Replace(Convert(char(8),getdate(),114),':',''))

  from msdb..sysjobhistory

• timingskey

  SSCommitted

  Points: 1708

  More actions

  April 23, 2003 at 7:27 pm

  #455118

  Thanks a lot! I'll give it a try!