Get list of jobs names along with the categories in a file

avulap · Post by **avulap** » Thu Apr 14, 2011 1:53 am

Hi,

In a particular datastage project I need all job names catergory wise in a file. I tried using dslog -ljobs but this gives only list of job names but they are not sorted based on the category. Please let me know if there is any way to do this. I am using DS7.5 version.

Thanks,
Pavithra.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 14, 2011 4:15 pm

Welcome aboard.

Yes, what you seek to do is possible via a query on the DS_JOBS table.

Search DSXchange for example queries.