Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql job showing wrong execution time in job's history Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 8:43 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, September 26, 2014 10:20 AM
Points: 537, Visits: 1,921
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?
Post #1467204
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse