what time is JOB_DURATION for

Question

is JOB_DURATION representing until run start time or until run end time?

Answer 1

@Zhou, Min (NonEmp)

The JOB_DURATION field typically represents the total time the job took to run, which means it's calculated from the job's start time to its end time. So yes, JOB_DURATION reflects the duration until the run end time, not just until the start time.

General Understanding of JOB_DURATION - The field JOB_DURATION typically represents how long a job ran, in total, and is calculated as: JOB_DURATION = Run End Time - Run Start Time

So, JOB_DURATION represents the duration from the run start time to the run end time.

Example:

Job Name	Run Start Time	Run End Time	JOB_DURATION
LoadData	2025-06-19 10:00PM	2025-06-19 10:15PM	15 minutes

So in this case:

• Run Start Time: 10:00 PM
• Run End Time: 10:15 PM
• JOB_DURATION: 15 minutes

This tells you the job took 15 minutes to complete, ending at 10:15 PM.

So, JOB_DURATION represents the total duration until the run end time, starting from the run start time.

I hope this information helps. Please do let us know if you have any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

As your feedback is valuable and can assist others in the community facing similar issues.

Thank you.