list of jobs using a certain environmental variable

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
just4u_sharath
Premium Member
Premium Member
Posts: 236
Joined: Sun Apr 01, 2007 7:41 am
Location: Michigan

list of jobs using a certain environmental variable

Post by just4u_sharath »

Hello,
Can you please let me know how I can list all the jobs that uses a certain environmental variable in a project.

Thanks
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

I wrote myself a script for that.

Code: Select all

#!/usr/bin/ksh
##
##  Description:  Scan all jobs in all project to see if they use a particular parameter passed to this script .
##
DSHOME=`cat /.dshome`;export DSHOME;
hName=`hostname`



set -A projects `$DSHOME/bin/dsjob -lprojects 2>/dev/null;`

for pEntry in ${projects[*]}; do
        echo "Examining $pEntry"

        set -A jList `$DSHOME/bin/dsjob -ljobs $pEntry 2>/dev/null;`

        for jEntry in ${jList[*]}; do

                $DSHOME/bin/dsjob -lparams $pEntry $jEntry 2>/dev/null | grep $1 1>/dev/null 2>/dev/null;
                status=$?
                if [[ $status -eq 0 ]]; then
                        echo "$jEntry is using $1"
                fi
        done
done
Post Reply