HOW TO GET "CATEGORY OF JOB" using dsjob command

chvenkat.v · Post by **chvenkat.v** » Tue Feb 01, 2011 6:30 am

HI,

I am using dsjob -report option to get the job details but in the report category was missing.

so can anyone please tell me " how to get the category by using dsjob command"

Thanks,
venkat.

Ravi.K · Post by **Ravi.K** » Tue Feb 01, 2011 7:05 am

Try with the below command it may help you.

dssearch -ljobs -matches -sub -oc Project_name JOBNAME

chvenkat.v · Post by **chvenkat.v** » Tue Feb 01, 2011 7:33 am

hi ravi

where can i find dssearch command. As in my project bin directory doesn't have dssearch command.

Thanks
venkat

Ravi.K · Post by **Ravi.K** » Tue Feb 01, 2011 7:48 am

I was tried from Client side.

The executable present at "Installation location\Ascential\DataStage7.5.1\dssearch.exe".

if you want try from Client side you need to additionally input the credentials.

Navigate to "Installation location\Ascential\DataStage7.5.1\"

if you find dssearch.exe then issue the following command.

dssearch -server SERVERIP -user USERNAME -password PASSWORD -ljobs -matches -sub -oc Project_name JOBBNAME

Additionally you can issue initial command at server itself where datastage is installed if dssearch.exe is available.

chvenkat.v · Post by **chvenkat.v** » Wed Feb 02, 2011 12:55 am

HI

can please tell me where can i find that command in aix box.

Thanks,
venkat

jwiles · Post by **jwiles** » Wed Feb 02, 2011 2:37 am

It will be in the $DSHOME/bin directory along with dsjob. However, if it doesn't exist then run your search on the client pc using the information Ravi provided.

Regards,