Page 1 of 1

Running Sequence from command line

Posted: Thu Jul 06, 2006 2:16 am
by bhaskarjha
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

Posted: Thu Jul 06, 2006 2:24 am
by opdas
I couldnt find any utility in DS server(Unix) for compilation as it can be done from client(windows) through command line.

Re: Running Sequence from command line

Posted: Thu Jul 06, 2006 3:36 am
by Klaus Schaefer
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

Posted: Thu Jul 06, 2006 5:23 am
by bhaskarjha
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,

Posted: Thu Jul 06, 2006 5:57 am
by ray.wurlod
There is no "compile from the command line" utility in the product.

Posted: Thu Jul 06, 2006 6:10 am
by kduke
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.

Posted: Thu Jul 06, 2006 6:34 am
by chulett
kduke wrote:It is well documented perhaps over documented.
:lol:

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!

Posted: Thu Jul 06, 2006 6:36 am
by DSguru2B
Over the command line, you cannot compile, just reset the job.

Posted: Thu Jul 06, 2006 5:55 pm
by kduke
That script does a reset if needed.

Posted: Thu Jul 06, 2006 6:30 pm
by chulett
As any good one should. :wink:

Posted: Thu Jul 06, 2006 9:11 pm
by ray.wurlod
kduke wrote:It is well documented perhaps over documented.
Done properly there is no such thing as over-documented, imho.

Posted: Thu Jul 06, 2006 10:42 pm
by kduke
I had a feeling you might think that.
:lol: