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
Getting the list of Jobs under each category
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the Administrator client Command window or in TCL on the server or via a UV stage in a job execute the following command:
You can adjust the FMT widths to suit. If using a UV stage (connected to localuv), leave them out altogether.
Code: Select all
SELECT NAME FMT '50L',CATEGORY FMT '25L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%' ORDER BY CATEGORY, NAME;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.