• Yes, days can be included on the value. You can test this by creating a job that just sits for a day. I have a messy formula to calculate the value.

    I like to deal with it in seconds so I use this:

    ((jh.run_duration/1000000)*86400) + (((jh.run_duration-((jh.run_duration/1000000)*1000000))/10000)*3600) + (((jh.run_duration-((jh.run_duration/10000)*10000))/100)*60) + (jh.run_duration-(jh.run_duration/100)*100)

    Where jh is the jobhistory table..

    CEWII