Hi,
I would like to list the jobs/sequencers under the folders of my project. For example, I have MYPROJECT project and folders FOLDER1, FOLDER2, FOLDER3, FOLDER4 and FOLDER5.
I would like to have an output which will give me the folder name and the jobs/sequencers under it:
FOLDER1:
Job1a
Job1b
Jobseq1c
FOLDER2:
Jobseq2a
Job2a
Job2b
...
FOLDER4:
Job3a
Job3seqa
Job3seqb
What function or can you pass me a sample routine that does this??
Thanks in advance..
Displaying jobs/sequencers in folders
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
SELECT BREAK ON "'O'" CATEGORY FMT '32L', NAME FMT '40L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%' ORDER BY 1,2;
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.