December 18, 2002 at 8:22 am
m extracting data out of the MSDB sysjobschedule table to see the times of the scheduled jobs. Based on the content I am trying to get the datetime the next time the job will execute. There is a next_run_time, but it is an int, that I am sure is a countdown to the execution time. Is there a way to capture,convert to find out what time the job is sheduled? -jG
-JG
-JG
December 18, 2002 at 9:22 am
You're going to actually have to parse it. It's in the format:
hhmmss
Where hh is the hours in 24-hour format. Not typically what you'd expect (usually when you see integer here you'd think seconds from some arbitrary date/time, but not in this case). It would make probably more sense logically if you saw the field as char(6) or varchar(6).
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
December 18, 2002 at 12:40 pm
Thanks Brian! -jG
-JG
-JG
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply