VIEW to list running and completed jobs

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

  • 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 1 (of 1 total)

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