QUEUEDJOB: STARTTIME, ACTSTARTTIME AND STOPTIME FORMATTING/CALCULATIONS

unknown

Does anyone do any kind of duration computations on job run times from the (GEN) QUEUEDJOB table, based on the difference between the start & stop times?

I'd like to do something like this, but since these fields are in decimal instead of time format, I am having trouble determining how to convert them to minutes & seconds. (Since it is job run times I am trying to convert, I shouldn't ever need to go as far out as hours, so would only need MM:SS)

Has anybody ever done this and would be willing to share how? Thanks.

d-hofmann

I exported data for specific payroll jobs to Excel and did computations to compare payroll runs to determine if we were seeing a increase in times. But only for that one instance. I think I change the column format from number to time to be able to get the calculations.



I generally judge how quickly my system is running by the timing of CU201. If it takes more than 2 seconds, then the system is slow.