October 23, 2006 at 4:20 pm
In msdb.dbo.sysjobhistory they have duration not in seconds or minutes, but in a format like 'ddhhmmss'. Does somebody have a function that converts it to seconds or minutes ?
Thanks
October 24, 2006 at 5:08 am
First, is it stored as text or a number?
October 24, 2006 at 8:16 am
It's a number. For example 101 means 1 min 1 sec.
October 24, 2006 at 9:00 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply