how to find out the jobs not in complied state using SQL

vij · Post by **vij** » Wed Sep 10, 2008 4:24 pm

hi,

I would like to know what is the command I can use to "select/find" the jobs which are not in complied state inside a category, using the SQL command, I mean from the Datastage adminstrator.

Thanks in advance,
Vij

ray.wurlod · Post by **ray.wurlod** » Wed Sep 10, 2008 5:12 pm

The status of each job is recorded in a separate table.

Therefore, at the innermost level, you need a separate query for each job.

Wrap that how you will, the bottom line is one query per job.