DSXchange

Posted: **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

Posted: **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.

DSXchange

Getting the list of Jobs under each category

Getting the list of Jobs under each category