UtilityRunJob with job parameter

eldonp · Post by **eldonp** » Wed May 17, 2006 12:51 am

I haven't figured out how to use a job parameter inside the UtilityRunJob utility. Given the following scenario.

Current jobname: JobParameters
Current job parameter name: JobToRun

Inside of a transformer stage, I have tried the following derivations:

UtilityRunJob('#JobToRun#','Project=':Link1.project,0,0)
UtilityRunJob("#JobToRun#",'Project=':Link1.project,0,0)
UtilityRunJob('JobToRun','Project=':Link1.project,0,0)
UtilityRunJob("JobToRun",'Project=':Link1.project,0,0)
UtilityRunJob(#JobToRun#,'Project=':Link1.project,0,0)
UtilityRunJob(JobToRun,'Project=':Link1.project,0,0)

None has worked yet.

ArndW · Post by **ArndW** » Wed May 17, 2006 2:14 am

The correct format was "UtilityRunJob(JobToRun,'Project=':Link1.project,0,0)". What happened when you tried that one (i.e. error message / warning / effects)? The parameter "Project" is case sensitive and must exist in the "JobToRun" job.

eldonp · Post by **eldonp** » Wed May 17, 2006 3:48 am

The problem I have is with the JobToRun parameter component. I can't get it to substitute the correct value at runtime.

Assigning the parameters to the job works ok. I do this by removing JobToRun and replacing it with the name of the job I want to run.

e.g.
UtilityRunJob('LoadCustFact','Project=':Link1.project,0,0) works ok.

but
UtilityRunJob('#JobToRun#','Project=':Link1.project,0,0) where the value of job parameter JobToRun at runtime is

LoadCustFact

does not work as I described above.

ArndW · Post by **ArndW** » Wed May 17, 2006 4:15 am

eldonp wrote:UtilityRunJob('#JobToRun#','Project=':Link1.project,0,0)

will not work, since it will not expand the value of the parameter and look for a job name starting and ending with hash marks. Specify the JobToRun with quotes and without hash marks, as per the previous post.