sql job showing wrong execution time in job's history

• DBA-640728

  SSChampion

  Points: 12898

  More actions

  June 25, 2013 at 8:43 am

  #278967

  hi i have a sql server 2008 r2 instance, after checking a few of my sql agent jobs, i see the last execution time being in the future. today's date is 6/24/13 and is showing it last executed on 6/28/13. i ran one of these job's manually and then it shows correct current time. I also checked server's time and it shows correct current time. I also checked the following:

  SELECT SYSDATETIME(),

  SYSDATETIMEOFFSET(),

  SYSUTCDATETIME(),

  CURRENT_TIMESTAMP,

  GETDATE(),

  GETUTCDATE()

  and they show the correct current time. Can anyone help?