Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

get oozie workflow name with start and end time in mail

Solved Go to solution

get oozie workflow name with start and end time in mail

New Contributor

Hi,i want to trigger mail with oozie workflow name and start and end time.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: get oozie workflow name with start and end time in mail

Expert Contributor

Hi @rajisridhar 

 

You can use a command like this to get the start and end time and then store it where you wish to or configure mail accordingly to your requirements.

Example:

$ oozie job -oozie http://localhost:11000/oozie -info 14-20090525161321-oozie-joe
.
.----------------------------------------------------------------------------------------------------------------------------------------------------------------
Workflow Name :  map-reduce-wf
App Path      :  hdfs://localhost:8020/user/joe/workflows/map-reduce
Status        :  SUCCEEDED
Run           :  0
User          :  joe
Group         :  users
Created       :  2009-05-26 05:01 +0000
Started       :  2009-05-26 05:01 +0000
Ended         :  2009-05-26 05:01 +0000
Actions
.----------------------------------------------------------------------------------------------------------------------------------------------------------------
Action Name             Type        Status     Transition  External Id            External Status  Error Code    Start                   End
.----------------------------------------------------------------------------------------------------------------------------------------------------------------
hadoop1                 map-reduce  OK         end         job_200904281535_0254  SUCCEEDED        -             2009-05-26 05:01 +0000  2009-05-26 05:01 +0000
.----------------------------------------------------------------------------------------------------------------------------------------------------------------

For detailed information see this:

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

View solution in original post

 

Hope this helps. Please accept the answer and vote up if it did.

View solution in original post

2 REPLIES 2
Highlighted

Re: get oozie workflow name with start and end time in mail

Expert Contributor

Hi @rajisridhar 

 

You can use a command like this to get the start and end time and then store it where you wish to or configure mail accordingly to your requirements.

Example:

$ oozie job -oozie http://localhost:11000/oozie -info 14-20090525161321-oozie-joe
.
.----------------------------------------------------------------------------------------------------------------------------------------------------------------
Workflow Name :  map-reduce-wf
App Path      :  hdfs://localhost:8020/user/joe/workflows/map-reduce
Status        :  SUCCEEDED
Run           :  0
User          :  joe
Group         :  users
Created       :  2009-05-26 05:01 +0000
Started       :  2009-05-26 05:01 +0000
Ended         :  2009-05-26 05:01 +0000
Actions
.----------------------------------------------------------------------------------------------------------------------------------------------------------------
Action Name             Type        Status     Transition  External Id            External Status  Error Code    Start                   End
.----------------------------------------------------------------------------------------------------------------------------------------------------------------
hadoop1                 map-reduce  OK         end         job_200904281535_0254  SUCCEEDED        -             2009-05-26 05:01 +0000  2009-05-26 05:01 +0000
.----------------------------------------------------------------------------------------------------------------------------------------------------------------

For detailed information see this:

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

View solution in original post

 

Hope this helps. Please accept the answer and vote up if it did.

View solution in original post

Highlighted

Re: get oozie workflow name with start and end time in mail

New Contributor

Hi @jagadeesan ,

 

i want result like this

workflow name and status,start and end time.we have 200 jobs.daily we doing manually.so need to update automatically.

workflownameIngestionDaily Completed9.00 PM7.36 AM
Don't have an account?
Coming from Hortonworks? Activate your account here