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.

How to see all oozie jobs/workflows which failed in last 7 days.

How to see all oozie jobs/workflows which failed in last 7 days.

I would like to have a command or script where I could see all the workflows which failed in oozie in the last say 7 days but really any time interval.

Where these workflows are mainly used for ingesting data.

Is this possible?

Thank you

4 REPLIES 4
Highlighted

Re: How to see all oozie jobs/workflows which failed in last 7 days.

Expert Contributor

1) With Oozie UI you can look at the status of all past workflows.

2) If you have smartsense activity explorer and analyzer setup, you can query all the job that ran from activity.job table within given specified period and job name /type containing "oozie" in it.

Highlighted

Re: How to see all oozie jobs/workflows which failed in last 7 days.

Thanks for the answer is there anyway I can do this through the command line though?

I know that there are a bunch of oozie terminal commands just not sure how to execute this from the command line.

I dont believe that I have any of the smartsense activity explorer and analyzer setup .

Highlighted

Re: How to see all oozie jobs/workflows which failed in last 7 days.

Expert Contributor

check this https://oozie.apache.org/docs/4.0.0/WebServicesAPI.html#Job_Log

You can use curl to run the rest api.

Highlighted

Re: How to see all oozie jobs/workflows which failed in last 7 days.

Explorer

You can use the following cmd

oozie jobs -filter status=FAILED -len 1000 -oozie http://localhost:11000/oozie

Don't have an account?
Coming from Hortonworks? Activate your account here