Get DataStage Job Information without using Director

With the help of this script, You can get the job no, category and other information without opening DataStage Director.

This Script need two arguments :
1. DataStage Project Name
2. DataStage Job Name

Script :

============================================================================

	# Script Name - DSgetJobNo.sh
	# Developer - Atul Singh
	# Description - This script query on the Datastage UV DB
	# and get the internal job no and catagory assigned to job
	# Date - Feb 25, 2014
	# Plateform - AIX,LINUX, UNIX, Solarix and all NIX
	#!/bin/ksh
	##!/bin/sh
	. /opt/IBM/InformationServer/Server/DSEngine/dsenv > /dev/null 2>&1
	DSProject="$1"
	DSJob="$2"
	if [[ -z "$DSProject" || -z "$DSJob" ]]; then
	echo "\nUsage: $0 <DSProject> <DSJob>\n"
	exit 1
	fi
	echo "Job Info for job(s): \"$DSJob\" in project: \"$DSProject\"..."
	export DSHOME=`cat /.dshome`
	cd $DSHOME
	./bin/uvsh << EOF 2> /dev/null
	LOGTO $DSProject
	SELECT @ID FMT '80L', CATEGORY FMT '80L', JOBNO FROM DS_JOBS WHERE NAME LIKE '%$DSJob%' OR JOBNO = '$DSJob' ORDER BY NAME;
	EOF

view raw DSgetJobNo.sh hosted with ❤ by GitHub

============================================================================


Please let me know if facing any issues with script while running/executing.


Visit this also - 
Know your DataStage Jobs Status without Director