Home Forums SQL Server 7,2000 Administration sysjobhistory run_duration RE: sysjobhistory run_duration
JG-324908
SSC-Addicted
Points: 462
More actions
December 23, 2010 at 12:48 am
#1265799
One more solution without case statement found in another forum,
SELECT stuff(stuff(replace(str(run_duration,6,0),' ','0'),3,0,':'),6,0,':') FROM sysJobHistory