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?
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 .