question How do I send a mail in Oozie by mentioning the Start Time and End Time in the mail body ? in Archives of Support Questions (Read Only)

How do I send a mail in Oozie by mentioning the Start Time and End Time in the mail body ?

sairamv — Mon, 25 Jul 2016 18:57:16 GMT

I need to capture the job status, Start time and End Time of the work and mail it using the mail action in Oozie.

Re: How do I send a mail in Oozie by mentioning the Start Time and End Time in the mail body ?

sairamv — Mon, 25 Jul 2016 19:07:09 GMT

@Neeraj Sabharwal

Re: How do I send a mail in Oozie by mentioning the Start Time and End Time in the mail body ?

sunile_manjee — Tue, 26 Jul 2016 04:42:55 GMT

You can do this by setting a parameter with start and end time.

For example

<property>
<name>the_timestamp</name>
<value>${timestamp()}</value>
<property>

Set that to start time and another to end time when you hit a action.

For information on oozie emails here:

https://oozie.apache.org/docs/3.3.0/DG_EmailActionExtension.html

Re: How do I send a mail in Oozie by mentioning the Start Time and End Time in the mail body ?

KuldeepK — Tue, 26 Jul 2016 11:35:12 GMT

@Sai ram

There are no direct variables to get start time and end time in oozie. '${timestamp()}' can return current timestamp in UTC. I would suggest to use another approach, start and end your oozie workflow with an email action, in this way, you will receive 2 emails, one when your oozie workflow will start and another when your job will end. If you want more better solution then I would suggest to write a script which will fetch start time, end time from oozie commands or from oozie database and have script to send an email for multiple jobs at once in a tabular format.

Hope this information helps.

Re: How do I send a mail in Oozie by mentioning the Start Time and End Time in the mail body ?

sairamv — Sun, 18 Aug 2019 13:27:36 GMT

I need to capture the highlighted fields in the screenshot.

Re: How do I send a mail in Oozie by mentioning the Start Time and End Time in the mail body ?

sairamv — Tue, 26 Jul 2016 12:42:16 GMT

Thanks, but I am not looking for timestamp, I need the job status and execution time. In short, I need to mail the output of this command, oozie job -oozie {SERVER_DETAILS} -info ${job_id}

Re: How do I send a mail in Oozie by mentioning the Start Time and End Time in the mail body ?

sairamv — Tue, 26 Jul 2016 12:42:59 GMT

@Kuldeep Kulkarni Is there a way where I can execute this command inside the mail action in oozie ?

oozie job -oozie {SERVER_DETAILS} -info ${job_id}

Re: How do I send a mail in Oozie by mentioning the Start Time and End Time in the mail body ?

KuldeepK — Tue, 26 Jul 2016 23:34:19 GMT

@Sai ram - No you cann't. But you can write a shell action and in shell script you can execute this command as well as mail command