I am executing query on msdb database on sysjobhistory table . This table contains field called run_time with ineger data type . I want this value to be converted into time .

I want to know Job name , Its start time , end time , total run time .

How can I achive this ?

Please let me know

-- Anonymous, May 07, 2002

Answers

Shrinivas,

Run_Date is yyyymmdd in integer form.

Run_Time is hhmmss in 24 hour time.

Duration is seconds.

Hope this helps,

Eric

-- Anonymous, May 08, 2002

KOL AIRI

-- Anonymous, June 10, 2004