Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
Madhav_M
- Participant
- Posts: 43
- Joined: Sat Jul 10, 2004 5:47 am
Post
by Madhav_M »
Hi,
Is there is any way to get list of job names under a folder in a project.
I am getting list of all jobs by using
dsjob -ljobs <project name>
is there is anyway to add folder name too.
Thanks
Madhav
-
kduke
- Charter Member
- Posts: 5227
- Joined: Thu May 29, 2003 9:47 am
- Location: Dallas, TX
-
Contact:
Post
by kduke »
You would have do it in SQL.
SELECT NAME FROM DS_JOBS WHERE CATEGORY = 'MyCat';
Mamu Kim
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Here are a couple of different ways. Not sure you can from dsjob, however.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
Madhav_M
- Participant
- Posts: 43
- Joined: Sat Jul 10, 2004 5:47 am
Post
by Madhav_M »
Hi
Thanks for your replies.. I saw the previous post also.
Where to use the Sql option and how to use it?
Thanks
Madhav
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Simplest place is from the 'Command' window of the Administrator.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
Madhav_M
- Participant
- Posts: 43
- Joined: Sat Jul 10, 2004 5:47 am
Post
by Madhav_M »
Thanks chulett