Getting the list of Jobs under each category

rkdatastage · Post by **rkdatastage** » Tue Mar 25, 2008 5:19 am

Hi All

I had a kind of problem , Kindly give me your valuable suggestions.

There are lot of jobs under each folder/Category , I need Category wise list of jobs and the sequences as a report. I had tried to generate a report by compiling Multiple jobs option . but the output is not satisfying my requirement. I need Category wise List of Jobs/Sequences. Is there any process that i can achive apart from manually writing them.

Thanks for your responses.

Regards
RK

ray.wurlod · Post by **ray.wurlod** » Tue Mar 25, 2008 5:42 am

In the Administrator client Command window or in TCL on the server or via a UV stage in a job execute the following command:

Code: Select all

SELECT NAME FMT '50L',CATEGORY FMT '25L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%' ORDER BY CATEGORY, NAME;

You can adjust the FMT widths to suit. If using a UV stage (connected to localuv), leave them out altogether.