Scheduler Usage

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

This will list all ended notok... you can grep for your own job name...

ctmlog listmsg "5134" 20100120 0000 20100705 0000| grep <job>

you can then script based on order ID, jobname, time/date.

output:
|Date|Time|Jobname |Order|SS|MID |Message