Page 1 of 2

Regarding Parameters

Posted: Thu Jan 11, 2007 2:06 pm
by vijaykumar
Hi Gurus,
I want to retrieve the actual value of the parameter using Operating system command utility.
please help me , Because my team lead wants to find a way retrieve the actual environmental variable value which we specify in the administrator using operating system utility.
plz Gurus help me

cheers;
vijay

Posted: Thu Jan 11, 2007 2:21 pm
by ray.wurlod
dsjob is the utility. You need to retrieve the "job started" event (find the newest log ID of type "started" using -lognewest option). Among other things, this reports the parameter values that were used for that run. Read the detail of that event using -logdetail option.

Posted: Thu Jan 11, 2007 2:27 pm
by vijaykumar
Hi Gurus,
can u please post the dscommand used to retrieve.

plz Gurus help me.

cheers;
vijay

Posted: Thu Jan 11, 2007 2:56 pm
by ray.wurlod
I did. :roll:

Posted: Thu Jan 11, 2007 3:06 pm
by ray.wurlod
Don't supply the user name. Or, if you need to, use the appropriate options for hostname, user name and password.

Type dsjob by itself to obtain a syntax summary.

Posted: Thu Jan 11, 2007 3:10 pm
by chulett
-useid does not mean userid but something else entirely that escapes me at the moment.

Posted: Thu Jan 11, 2007 3:22 pm
by I_Server_Whale
vijaykumar wrote: plz help me in listing the actual value of the parameter.
Note:
dsjob -lparams command will list all the parameters used for a particular job. It will not return you a value of a specific parameter.

Whale.

Posted: Thu Jan 11, 2007 3:24 pm
by DSguru2B
I_Server_Whale wrote: Refer to the Server Job Developer Guide pdf manual.
Look for complete sytax there. lparams will list all the params the job is using and not the value for that param. You need the option -paraminfo with dsjob.

Code: Select all

dsjob -paraminfo <Projectname> <JobName> <ParameterName>

Posted: Thu Jan 11, 2007 3:25 pm
by ray.wurlod
Option -paraminfo gives the default value, not the actual runtime value. You need to get this from the job log, as I outlined earlier.

Posted: Thu Jan 11, 2007 3:32 pm
by I_Server_Whale
vijaykumar wrote:Because my team lead wants to find a way retrieve the actual environmental variable value which we specify in the administrator using operating system utility.
Didn't the OP want the default value assigned in the Administrator?
DSguru2B wrote:Look for complete sytax there. lparams will list all the params the job is using and not the value for that param. You need the option -paraminfo with dsjob.

Code: Select all

dsjob -paraminfo <Projectname> <JobName> <ParameterName>
Phew! :oops: Somehow, I forgot/missed about that one completely. Thanks DSguru2B for reviving one of my neurons. :)

Whale.

Posted: Thu Jan 11, 2007 3:38 pm
by chulett
Wsn't going to mention that, figured someone else would. Just wanted to get the syntax straightened out.

Posted: Thu Jan 11, 2007 3:56 pm
by I_Server_Whale
I think 'Que' pronounced as 'k' stands for 'who' or 'whom' in spanish.

Posted: Thu Jan 11, 2007 3:57 pm
by chulett
Spanish for 'what'. And 'they' use question marks at each end (the first one upside-down) to make a phrase a question.

Much like saying Huh? :wink:

Posted: Thu Jan 11, 2007 4:24 pm
by vijaykumar
Hi Gurus,
I don't know the operating system to get the job id.
I used the command
DSJOB -1params [useid] salma10 job1

Iam getting error
status code=-9999 DSJE_DSJOB_ERROR.

why am i getting this error, its because i didn't use the jobid.
My operating system is windows, how to get jobid.

please help me Gurus.

cheers;
vijay

Posted: Thu Jan 11, 2007 4:30 pm
by narasimha
Don't use [useid]
Try

Code: Select all

dsjob -lparams salma10 job1