Report for chronically abending jobs

Several scripts
Post Reply
User avatar
gratedsandy
Nouveau
Nouveau
Posts: 37
Joined: 14 Mar 2007 12:00

Report for chronically abending jobs

Post by gratedsandy » 28 Jun 2010 2:55

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

User avatar
Eight
Nouveau
Nouveau
Posts: 41
Joined: 03 May 2010 12:00

Post by Eight » 05 Jul 2010 9:32

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

Post Reply