Running same job multiple times for different records

Suman · Post by **Suman** » Wed Nov 14, 2007 5:59 am

Hi,
I have a job which is loading using BAPI to SAP from an Oracle table. I want to run this job for every 1000 records in a sequential way several times. Is there any way to automate this in datastage. I do not want to run the job in multiple instance.For example if the Oracle table has 20050 records the number of times this job should run is 21. The number of runs will vary with the number of records in the table.

Regards,
Suman

ray.wurlod · Post by **ray.wurlod** » Wed Nov 14, 2007 6:05 am

In a job sequence get the count. Create a counted loop in the job sequence in which the start value is 1, the increment is 1000, and the limit is the count obtained from the table. When running the job within the loop assign one job parameter with the loop index variable ($Counter) and another with a value 999 higher. Use these job parameters in the WHERE clause when selecting from the Oracle table.