getting list of jobs and sequences

times29 · Post by **times29** » Tue Mar 05, 2013 4:39 pm

Hi,
I have lot of jobs and sequences .

I want to get list of all jobs and sequences in a project is there easy way to do it.

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Mar 05, 2013 6:33 pm

Open Director.
Disable auto-refresh.
Disable display of categories.
There's your list. Sort it how you will.
From the Project menu choose Print.
In the Print dialog, choose Print To File.
When done, re-enable display of categories and auto-refresh.

prasannakumarkk · Post by **prasannakumarkk** » Tue Mar 05, 2013 11:41 pm

there are lot of ways to acheive it.

Predominant way of getting the list is by using
dsjob -ljobs project
command. You can even specify the category/folder from where things have to be pulled

if you have dsadmin with you. Hit the xmeta to get the complete metadata of jobs.

times29 · Post by **times29** » Wed Mar 06, 2013 9:37 am

i went to project path
did

dsjob -ljobs project

got error
dsjob:not found

prasannakumarkk · Post by **prasannakumarkk** » Wed Mar 06, 2013 9:43 am

echo $DSHOME
Go to this path.in bin folder run the command

Give your project name not project

times29 · Post by **times29** » Wed Mar 06, 2013 10:27 am

sorry not that good at unix thats what i did

khel: $pwd
/export/home/abc

khel$ echo $DSHOME

again did
khel: $pwd

i am still in

/export/home/abc

prasannakumarkk · Post by **prasannakumarkk** » Wed Mar 06, 2013 10:34 am

You have to navigate to the datastage installation directory and in bin folder you have to invoke dsjob . In the above echo if you have not received any output then I guess you are in a Unix box where datastage is not installed or the user doesnt have proper privilege

ray.wurlod · Post by **ray.wurlod** » Wed Mar 06, 2013 3:27 pm

Code: Select all

DSHOME=`cat /.dshome`
export DSHOME
cd $DSHOME
. ./.dsenv
bin/dsjob options...

chulett · Post by **chulett** » Thu Mar 07, 2013 7:46 am

prasannakumarkk wrote:You have to navigate to the datastage installation directory and in bin folder you have to invoke dsjob.

Have to? No. You just need to understand full v. relative paths and work with how your PATH environment variable is set up.

prasannakumarkk · Post by **prasannakumarkk** » Thu Mar 07, 2013 8:08 am

Have to? No. You just need to understand full v. relative paths and work with how your PATH environment variable is set up.

yeah we can do it. as the user was novice didnt explain