No of warning in the current job run

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Archana
Participant
Posts: 15
Joined: Thu Mar 23, 2006 3:55 am
Location: Hyderabad
Contact:

No of warning in the current job run

Post by Archana »

Hi ,

How do we get the number of warnings in the current run of the job ?

We tried with
dsjob -logsum -type WARNING <project> <job> | grep -c WARNING

It gives no of warnings in the whole lot of jobs present in the director.

We want the number of warnings in the log of the current job ran .
Archana
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Limit the report to those events whose timestamp is later than the timestamp of the "job started" event for the current job.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
singhald
Participant
Posts: 180
Joined: Tue Aug 23, 2005 2:50 am
Location: Bangalore
Contact:

Post by singhald »

Hello Archana,

first you need to find out the latest job control event ID.

you can use the below command

dsjob -logsum -type STARTED -max 2 DSProj DSJobName

it will give you two even id, just subtract them and use the result in the below command to get the count of warning messages in the current run of the ds job.

dsjob -logsum -max [Result] DSProj DSJobName | grep warning |wc -l
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Post Reply