Running Sequence from command line

bhaskarjha · Post by **bhaskarjha** » Thu Jul 06, 2006 2:16 am

Hi,
I am running sequence from command line of Unix. The sequence run properly when I compile the sequence & the included jobs in that sequence. But If I run the sequence without compiling it then I get the error "Job/Sequence is not in runnable state". I would like to know whether is it possible to compile the job/sequence from Unix.

Thanks,
Bhaskar

opdas · Post by **opdas** » Thu Jul 06, 2006 2:24 am

I couldnt find any utility in DS server(Unix) for compilation as it can be done from client(windows) through command line.

Klaus Schaefer · Post by **Klaus Schaefer** » Thu Jul 06, 2006 3:36 am

Your sequence seems to be aborting for some reason. You should first look into why it is aborting, because this will set your sequence into a "not runnable" state.

If you trigger your sequence from a job activity, you could use the execution action "reset if required then run" to get the sequence back into a runnable state and run it.

Klaus

bhaskarjha · Post by **bhaskarjha** » Thu Jul 06, 2006 5:23 am

Thanks Clauss,
Yes the reason behind is the previous status of sequence was aborted I used the command to reset its status. And now its running fine.
Thanks,

ray.wurlod · Post by **ray.wurlod** » Thu Jul 06, 2006 5:57 am

There is no "compile from the command line" utility in the product.

kduke · Post by **kduke** » Thu Jul 06, 2006 6:10 am

I posted a shell script which looks at the current job status. If the job aborted then it does a dsjob -RESET before it tries to start the job.

viewtopic.php?t=93365 is where RunJob.ksh is. It is well documented perhaps over documented.

chulett · Post by **chulett** » Thu Jul 06, 2006 6:34 am

kduke wrote:It is well documented perhaps over documented.

Everyone should have something like Kim's "over documented" wrapper script for launching any kind of DataStage job via dsjob. There's no reason on the planet not to, even if you can't roll your own there's more than one posted here for the taking!

DSguru2B · Post by **DSguru2B** » Thu Jul 06, 2006 6:36 am

Over the command line, you cannot compile, just reset the job.

kduke · Post by **kduke** » Thu Jul 06, 2006 5:55 pm

That script does a reset if needed.

chulett · Post by **chulett** » Thu Jul 06, 2006 6:30 pm

As any good one should.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 06, 2006 9:11 pm

kduke wrote:It is well documented perhaps over documented.

Done properly there is no such thing as over-documented, imho.

kduke · Post by **kduke** » Thu Jul 06, 2006 10:42 pm

I had a feeling you might think that.

DSXchange

Running Sequence from command line

Running Sequence from command line

Re: Running Sequence from command line