https://community.cloudera.com/t5/Archives-of-Support-Questions/Get-the-length-of-time-an-oozie-workflow-took-to-complete-in/m-p/192590#M65274 <P>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.</P><P>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.</P><P>I could just write the logs of each workflow to the logFile but would rather just have the jobId and the time numerically.</P><P>Thanks</P> Thu, 20 Jul 2017 20:29:33 GMT Former Member 2017-07-20T20:29:33Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Get-the-length-of-time-an-oozie-workflow-took-to-complete-in/m-p/192590#M65274 <P>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.</P><P>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.</P><P>I could just write the logs of each workflow to the logFile but would rather just have the jobId and the time numerically.</P><P>Thanks</P> Thu, 20 Jul 2017 20:29:33 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Get-the-length-of-time-an-oozie-workflow-took-to-complete-in/m-p/192590#M65274 Former Member 2017-07-20T20:29:33Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Get-the-length-of-time-an-oozie-workflow-took-to-complete-in/m-p/192591#M65275 <P><A rel="user" href="https://community.cloudera.com/users/9304/tspann.html" nodeid="9304"></A></P>@<A href="https://community.hortonworks.com/users/16464/yanks09champs.html">na</A><P>You can use a command like this to get the start and end time and then store it where you wish to:</P><PRE>oozie jobs -oozie <A href="http://localhost:11000/oozie" target="_blank">http://localhost:11000/oozie</A> -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 - .----------------------------------------------------------------------------------------------------------------------------------------------------------------</PRE><P>For detailed information see this:</P><P><A target="_blank" href="https://oozie.apache.org/docs/3.3.2/DG_CommandLineTool.html#Jobs_Operations">https://oozie.apache.org/docs/3.3.2/DG_CommandLineTool.html#Jobs_Operations</A></P> Fri, 21 Jul 2017 03:59:07 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Get-the-length-of-time-an-oozie-workflow-took-to-complete-in/m-p/192591#M65275 rbiswas1 2017-07-21T03:59:07Z