DSXchange

Posted: **Tue Aug 08, 2006 12:45 am**

mohanraj wrote:My actuall problem is like this

My job sequence contains 10 jobs and all the jobs contains 10 tables with one common column batch_SID.If I run this sequence then all the tables should get same batch serial number.
How can I achieve this?

Thanks in advance

Mohan

Have batch serial number as a job parameter in all the jobs.

Posted: **Tue Aug 08, 2006 5:13 am**

As already suggested job parameter is the way to go.

Add a routine Activity to the Master Sequence calling the server jobs. Pass the return value of the routine to all the 10 jobs as parameter.

DSXchange

batch SID