Job from command prompt

svhari76 · Post by **svhari76** » Mon Jan 03, 2011 2:44 pm

Hi

I am trying to run the job from command prompt and i am getting this.
Parameter file below is given correct path. Job has been kicked off but getting below error.

Code: Select all

From command prompt

./dsjob -server SERVERNAME-user userid -password pwd -run -param ParameterFile="SrcDir/ETLParamFile.dat" -warn 5000 project JOBNAME

In director logs

JOBNAME..JobControl (fatal error from Msg): Could not create the file: /JOBNAME.wrn

chulett · Post by **chulett** » Mon Jan 03, 2011 6:58 pm

Does this job run correctly from the Director and the only time you have an issue is from the command line?

svhari76 · Post by **svhari76** » Wed Jan 12, 2011 10:35 am

batch job calls -->Individual job

No, the batch job is not working from director too.

The individual job runs fine in designer and from director. But when i try from batch job to invoke individual job it fails with the message described in my first post.

Another thing i learnt was, If the batch file is named as 'Batch::ProcessJob' it is not working. If i name it as 'ProcessJob' it works fine from director.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 12, 2011 4:32 pm

Why are you trying to create the warning file in the root directory? It's probably correct that you don't have write permission there.

svhari76 · Post by **svhari76** » Fri Jan 14, 2011 9:40 am

I am not creating any files. Looks like by default batch file execution causes the creation of the files at root and since my user id doesn't have access permission it is failing.

In execution wise how Batch:: is different from regular job execution?

ray.wurlod · Post by **ray.wurlod** » Fri Jan 14, 2011 2:30 pm

Execution-wise Batch:: is just the same as a sequence job which, in turn, is the same as a server job that contains no stages but only a job control routine.

svhari76 · Post by **svhari76** » Tue Jan 18, 2011 10:58 am

I should be able to pass the parameters to a job from batch Job( can call this as batch job with out naming it as Batch::?) but when i try the same from sequencer to job i am not getting the parameters.

Any clue?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 18, 2011 3:36 pm

No, because you have not informed us how you are trying to pass the parameter values. I assume you mean to a sequence, rather than to a sequencer.

svhari76 · Post by **svhari76** » Fri Jan 21, 2011 3:54 pm

Ok, This might help to figure out the issue.

These are the sequence of commadns i am executing.

Code: Select all

cd /dvl/etl/Ascential/DataStage/DSEngine

/dvl/etl/Ascential/DataStage/DSEngine>. ./dsenv

/dvl/etl/Ascential/DataStage/DSEngine>cd /dvl/etl/Ascential/DataStage/DSEngine/bin

/dvl/etl/Ascential/DataStage/DSEngine/bin>./dsjob -server SERVERNAME-user userid -password pwd -run -param ParameterFile="SrcDir/ETLParamFile.dat" -warn 5000 project JOBNAME

JOBNAME above is just job name no directory path.

Am i suppose to be running it from some where else other than /dvl/etl/Ascential/DataStage/DSEngine/bin to avoid creating the log/warn files in root directory?

svhari76 · Post by **svhari76** » Wed Jan 26, 2011 9:40 am

Any help would be great

PaulVL · Post by **PaulVL** » Wed Jan 26, 2011 1:51 pm

>./dsjob -server SERVERNAME-user

Try a space between SERVERNAME and the -user.

???

svhari76 · Post by **svhari76** » Wed Jan 26, 2011 2:00 pm

Please forget about the syntax problems here...this is display/copy paste issue. Otherwise it should have been thowing different syntax related issue.
The problem here is trying to kick off the job, but due to not able to create the .wrn or .log file it fails.

47shailesh · Post by **47shailesh** » Wed Jan 26, 2011 2:29 pm

in dsenv check if any temp directory is set to root.