How to copy the datastage job name into a file

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
chpraveen.msc
Participant
Posts: 26
Joined: Tue Nov 08, 2005 5:36 am

How to copy the datastage job name into a file

Post by chpraveen.msc »

Hi All,
How to copy the datastage job names to a file after fetching the information from Datastage Administrator command line.
In our project some around 1000 jobs are there, We want all the Jobs names in a file.which will be helpful for our client. We are able to fetch the informtion of the jobs names by executing the command "LIST DS_JOBS" but we dont find any option the copy the jobs names to a file.
Experts please help me out in this.

Thanks in advance.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The equivalent of tee is to execute

Code: Select all

COMO ON {filename}
, then your commands, and

Code: Select all

COMO OFF
. This will create a sequential file called {filename} in the project &COMO& subdirectory. or use the dsjob command
Last edited by ArndW on Fri Dec 01, 2006 6:15 am, edited 1 time in total.
aakashahuja
Premium Member
Premium Member
Posts: 210
Joined: Wed Feb 16, 2005 7:17 am

Post by aakashahuja »

Write a shell script. Use dsjob command

dsjob -server <server> -user <user_name> -passowrd <password> -ljobs <project_name>

Pass the output to a file where ever u want.

I am sure this will help.
aakashahuja
Premium Member
Premium Member
Posts: 210
Joined: Wed Feb 16, 2005 7:17 am

Post by aakashahuja »

Before running dsjob, you will need to

1. be in the engine directory
2. execute . ./dsenv
3. go to bin (inside the engine directory) subdirectory
4. then execute dsjob

the same has to be coded in teh script if you go for it or you can then run it as a one off command from the command line and pass the results to a file.
chpraveen.msc
Participant
Posts: 26
Joined: Tue Nov 08, 2005 5:36 am

How to copy the datastage job name into a file

Post by chpraveen.msc »

Hi All
Thankyou very. Finally i am able to crack it with your help.
Post Reply