Get the length of time an oozie workflow took to complete in minutes or seconds.

[#1]

Is there anyway through a command that I could get from the logs and the jobId the length in minutes or seconds that the oozie workflow took to complete.

I can look at the logs and see visually how long the workflow took from the jobId from start time to end time but what about if I would like to store this numerically in a log file for every jobId.

I could just write the logs of each workflow to the logFile but would rather just have the jobId and the time numerically.

Thanks

[#2 · Accepted solution]

@na

You can use a command like this to get the start and end time and then store it where you wish to:

oozie jobs -oozie http://localhost:11000/oozie -localtime -len 2 -fliter status=RUNNING



Job Id                          Workflow Name         Status     Run  User      Group     Created                Started                 Ended
.----------------------------------------------------------------------------------------------------------------------------------------------------------------
4-20090527151008-oozie-joe     hadoopel-wf           RUNNING    0    joe      other     2009-05-27 15:34 +0530 2009-05-27 15:34 +0530  -
0-20090527151008-oozie-joe     hadoopel-wf           RUNNING    0    joe      other     2009-05-27 15:15 +0530 2009-05-27 15:15 +0530  -
.----------------------------------------------------------------------------------------------------------------------------------------------------------------

For detailed information see this:

https://oozie.apache.org/docs/3.3.2/DG_CommandLineTool.html#Jobs_Operations