Job names in the folder??

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

Post Reply
Madhav_M
Participant
Posts: 43
Joined: Sat Jul 10, 2004 5:47 am

Job names in the folder??

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
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
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
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
Post Reply