warning count for all the jobs in project

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
mohan
Premium Member
Premium Member
Posts: 8
Joined: Tue Aug 10, 2004 1:35 am

warning count for all the jobs in project

Post by mohan »

Hi All,

I have a requirement in which I need to collect the name of all the jobs in a project which had warnings in last run. Also I would like to know the warning count for each job.

Your help is appreciated.

Thanks and Regards,
Mohan
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

OK. What have you tried so far or thought might be the approach you'll take?

Look into the various command line dsjob options. First, you could use "-ljobs" to get a list of all jobs in the project and then use "-jobinfo" to check the most recent run status in a loop to identify which ones qualify for further processing. Lastly, "-lognewest" and "-logdetail" can pull out the information you are looking for.

Or you could do the equivalent from a job, me I'd use a Server job for that along with a custom routine or two. There are "DSGet" function equivalents for all of the dsjob options noted above.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply