I am trying to come up with a report ( shell or sql) that will show jobs that have ENDED NOTOK consecutively for the last 3 runs.
However, I'm in a fix cause the last 3 runs could either be on
1. The Same ODATE ( for cyclic jobs)
2. Consecutive ODATE ( for DAILY jobs)
3. Weekly jobs ( ODATES between weeks)
4. MOnthly jobs ( ODATES across a month)
Can someone suggest some way of making a comparison while puling up this report that will ensure it include jobs with all the above frequencies ?
Thanks,
Sandeep