Support Questions

Find answers, ask questions, and share your expertise
Celebrating as our community reaches 100,000 members! Thank you!

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


Super Collaborator

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.


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 .

Super Collaborator

check this

You can use curl to run the rest api.

Rising Star

You can use the following cmd

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