Page 1 of 1

server routine in sequence with parallel job in job activity

Posted: Tue Feb 17, 2009 7:15 am
by pankajp123
Hi

How it will effect if i use server routine in a sequence where job activity will run a parallel job. My basic intention is to avoid writing C++ routine required for writing parallel routine.
Here is my job design-
routine activity ----job activity--- routine activity

1.Here first routine activity will write some entries like job execution time, Job name in one of the audit table.That will be done through calling perl script in job routine.
2.Job activity will be used to call a job
3.Last routine activity will be used to call orchadmin rm command to delete dataset.

We have datastage 8.1 version installed on windows server platform.

Thanks and regards,
Pankaj Pathak

Posted: Tue Feb 17, 2009 7:38 am
by Sainath.Srinivasan
Parallel routines are to be used within jobs.

Re: server routine in sequence with parallel job in job acti

Posted: Tue Feb 17, 2009 8:33 am
by chulett
pankajp123 wrote:How it will effect if i use server routine in a sequence where job activity will run a parallel job.
There is no 'effect', that's how they are meant to be used - Server routines with any combination of Server or PX jobs.

Posted: Tue Feb 17, 2009 2:45 pm
by ray.wurlod
Indeed the only type of routine that can be invoked by a job sequence's Routine activity is a server routine whose type is "tranform function".