batch SID

[balajisr]

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.

[loveojha2]

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.