Resetiing a job via shell script

sjordery · Post by **sjordery** » Wed Jul 01, 2009 4:26 am

Hi All,

I have a scheduled data stage job run via below script on daily basis.

#! /usr/bin/sh
dshome=`cat /.dshome`;
export dshome
PATH=$PATH:$dshome/bin;
export PATH
. $dshome/dsenv

dsjob -run -param source_file=$1 Test_Project Seq_job.$2

Some times the job gets aborted due to avoidable issues like file didnt land because of market holiday yesterday.

So is it possible to add any command in the same script to reset the sequence job and all the jobs called from the sequence job if it has aborte last time?

Thanks in advance.
Sjordery.

ArndW · Post by **ArndW** » Wed Jul 01, 2009 4:29 am

dsjob -run -mode RESET

sjordery · Post by **sjordery** » Wed Jul 01, 2009 4:50 am

Thanks ArndW.
I tried that but its prompting with error

'Status code = -2 DSJE_BADSTATE
Error running job"

Does the command resets all the jobs called from the sequence jobs along with the main sequence job?
below is the script I am using.

-------------------------------------------------------------------------------------
#! /usr/bin/sh
dshome=`cat /.dshome`;
export dshome
PATH=$PATH:$dshome/bin;
export PATH
. $dshome/dsenv

dsjob -run -mode RESET -param source_file=$1 Test_Project Seq_job.$2

-------------------------------------------------------------------------------------

Thanks,
SJordery.

ArndW · Post by **ArndW** » Wed Jul 01, 2009 5:55 am

You need 2 separate calls, the first to RESET, then the 2nd to run.

chulett · Post by **chulett** » Wed Jul 01, 2009 6:10 am

And no, it only resets the job mentioned on the command line, no others automagically. Your Sequence job should be setup to do the resetting of any 'child' jobs it runs using the 'Reset if required then run' option in the Job Activity stage.