Page 1 of 1

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

Posted: Thu Apr 14, 2011 1:53 am
by avulap
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.

Posted: Thu Apr 14, 2011 4:15 pm
by ray.wurlod
Welcome aboard.

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

Search DSXchange for example queries.