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

[#1]

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

[#2]

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.

[#3]

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 .

[#4]

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

You can use curl to run the rest api.

[#5]

You can use the following cmd

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