Showing posts with label Finding Datastage jobs through unix. Show all posts
Showing posts with label Finding Datastage jobs through unix. Show all posts

Tuesday, May 27, 2008

This talks about the usage of 'dsjob' command in Datastage. I have develop one small script which will help in finding the job locations.
This script uses two parameters: 1.ProjectName 2.JobName
#!/bin/ksh
. $DSHOME/dsenv
proj=$1
jobname=$2
# You have to search where exactly your project is placed.
#In our case it is in below mentioned path
cd /data/projectlib/$proj
echo Location for the job $jobname is
$DSHOME/bin/uvsh "SELECT CATEGORY FROM DS_JOBS WHERE NAME = '$jobname';"

About Me

Pune, Maharashtra, India
Datastage Developer ;)