msdb..sysjobhistory

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Cory E. SSCertifiable Points: 7076 More actions · Answer 1

BOL search for sysjobhistory will tell you this as well:

-- Cory

Steve Vos Right there with Babe Points: 757 More actions · Answer 2

Owkey, but there's nothings said over a run_time with a value of 0 or 1 :/

jaypee_s Right there with Babe Points: 793 More actions · Answer 3

Hi.

Check this link.. u may get the solution

Thanks

jaypee

SQLZ SSChampion Points: 12872 More actions · Answer 4

run_time is an integer and is the time at which a job started. The key thing to remember is that it's an integer not a datetime. So....

A run_time value of:

0 = 00:00:00

1 = 00:00:01

100 = :00:01:00

5000 = 00:50:00

50005 = 05:00:05

and so on....

It wouldn't be difficult to write a function that takes an integer and converts it to a readable time value.

Hope that helps.