Passing parameter to Job Activity in a Job Sequence

narasimha · Post by **narasimha** » Thu Jul 13, 2006 1:40 pm

Is there a possibility to pass a job name as a parameter to a Job Activity in a sequence job.

Details...

I have a complex job sequence consisting of many jobs.
I need to replicate the job sequence by changing the job names in a few Job Activities.
Wanted to know if there is a way I could parameterize the job name in the Job Activity.
If no Is there is any other approach?

sri1dhar · Post by **sri1dhar** » Thu Jul 13, 2006 2:00 pm

I don't think you can parameterize the job name in job activity. The other approach is to develop a routine to call the job. Routine takes the job name and job parameters as parameters. Call the routine in the sequence using routine activity with job name as parameter.

DSguru2B · Post by **DSguru2B** » Thu Jul 13, 2006 2:10 pm

If the entire sequence, with the exception of a few jobs, needs to be run again, then the simplest way is to make a copy of that job and then change the few jobs you want to be changed.
IMHO.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 13, 2006 5:25 pm

The routine exists; it's in the SDK and it's called UtilityRunJob. If you don't like exactly how it works, clone and customise.

narasimha · Post by **narasimha** » Fri Jul 14, 2006 11:16 am

Thanks Ray

Exactly what I wanted. :D
But I guess there is one gotcha, there is no way to encrypt the parameters, or is there?

ray.wurlod · Post by **ray.wurlod** » Fri Jul 14, 2006 11:35 am

Only by passing a reference to an encrypted parameter.