How to differentiate a Job from a Job Sequence in script

ray.wurlod · Post by **ray.wurlod** » Sun Aug 23, 2009 5:51 pm

PTERM CASE INVERT as a default stems from the early days if UniVerse (and precursor products) when the input device was a teletypewriter that only had upper case; this default recognizes the fact that most components are named in all upper case because of this historical artifact. You can institute automatic change of the default in the LOGIN paragraph.

sbass1 · Post by **sbass1** » Sun Aug 23, 2009 11:30 pm

I tried this from my home directory in a bash shell:

Code: Select all

sbass1:~ > uvsh <<EOF
> LOGTO DEV_GGS
> SELECT JOBTYPE,NAME FROM DS_JOBS WHERE NAME='TestJob_Seq' AND JOBTYPE='2'
> EOF
This directory is not set up for DataStage.
Would you like to set it up (Y/N)?LOGTO DEV_GGS

So, is there any way to invoke uvsh or dssh without actually cd'ing to a project directory?

chulett · Post by **chulett** » Mon Aug 24, 2009 5:51 am

You have to start from either $DSHOME or a Project directory to avoid that question... which should always be answered 'NO' by the way.

sbass1 · Post by **sbass1** » Mon Aug 24, 2009 9:58 pm

As always, thanks for the help Craig. Genuinely appreciated.

In case others might find this useful, here is my final (test) script. It was slightly tricky getting the here document output captured in a variable, but Google saved the day:

Code: Select all

#!/bin/bash

cd $DSHOME
FOUND=$(uvsh <<EOF | egrep 'records listed' | cut -f1 -d" "
LOGTO $1
SELECT NAME,JOBTYPE FROM DS_JOBS WHERE NAME='$2' AND JOBTYPE='2';
EOF)

echo $FOUND

$1 is the Project Name
$2 is the JobName

Returns 1 if JobName is a sequence, 0 if JobName is not a sequence.

zulfi123786 · Post by **zulfi123786** » Wed Apr 18, 2012 11:55 pm

A slight addition to the long discussion :D

Not all of my sequences are checkpointed and my intension is to figure out if the sequence i am running is checkpointed or not (by looking into the repository) and based on this either to reset or leave it in aborted/restartable status

Any info would be greatly appreciated

Thanks

zulfi123786 · Post by **zulfi123786** » Mon Apr 23, 2012 12:58 am

Guru's, could some one please help in the above query ?

chulett · Post by **chulett** » Mon Apr 23, 2012 6:25 am

No clue and obviously not something documented either. Have you asked your official support provider?

FranklinE · Post by **FranklinE** » Mon Apr 23, 2012 2:14 pm

Here are sample Director messages for a checkpointed job, with actual names genericized:

Code: Select all

<sequence job name>..JobControl (@Coordinator): Starting new run of checkpointed Sequence job

<sequence job name>..JobControl (@<sequence stage 1 name>): Checkpointed run of job '<job 1 called by sequence stage 1>'

<sequence job name>..JobControl (@<sequence stage 2 name>): Checkpointed run of job '<job 2 called by sequence stage 2>'

<sequence job name>..JobControl (@Coordinator): Removed checkpoint record at successful completion of sequence

In light of past threads discussing extracting log messages, I suppose you could use those to find checkpointed jobs, and have negative proof that jobs that lack those messages are not checkpointed.