When run_duration exceeded 100 hours than LEN(run_duration)>6..

The end time could be counted like this:

DATEADD(second,

[run_duration]/10000*3600+[run_duration]%10000/100*60+[run_duration]%100,

STR(run_date,8)+' '+STUFF(STUFF(RIGHT(1000000+run_time,6),5,0,':'),3,0,':'))

I don't know the way to get end time,

but I think, the simpliest way to get starting datetime from sysjobhistory is:

STR(run_date,8)+' '+STUFF(STUFF(RIGHT(1000000+run_time,6),5,0,':'),3,0,':')

or

CONVERT(DATETIME,STR(run_date,8)+' '+STUFF(STUFF(RIGHT(1000000+run_time,6),5,0,':'),3,0,':'))

.

You are querying msdb database, but what if it was restored manually.

Not by SQL agent job.

Piotr

I think, this topic is about backing up databases (database files) with Volume Shadow Copy and SQL 2000 support, so why to talk about Visual SourceSafe ?