VIEW to list running and completed jobs

  • deanbell2000

    SSC Rookie

    Points: 47

    Comments posted to this topic are about the item VIEW to list running and completed jobs

  • John H Davis

    SSChasing Mays

    Points: 622

    I tried this & I got a conversion error converting datetime to character string. I figured out the error occurred on the conversion of the run_duration column where the column had negative values. Did some Binging (I don't Goggle) & determined the run_duration column is negative if a job is running when the time changes on a server, i.e. when the time changes backward for daylight savings.

    Does anyone have any idea how to calculate the run duration when this occurs? I am just curious, not a real problem I need to solve.

Viewing 2 posts - 1 through 2 (of 2 total)

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