Job Iterations

I have a job that accepts a parameter. The parameter is dynamic in such a way that it is read from a database table. So if the table has 5 records, the job should iterate 5x, that is, once for each record in the table as its parameter. Please help.

Same here. Please specify your environment.

We're using linux and Datastage for the jobs; MP Version

What's Datastage?

Just to be sure. Are you running 24x7 Scheduler Multi-platform Edition? If yes, which version?

DataStage is an ETL tool.. We're using the MP trial version, we need to test if it is possible to use 24x7 in all the types of jobs we have before purchasing.

I suggest using a JavaScript job for this purpose. Start with setting up a database connection profile for your database. Create a job of script type. For the script flavor choose JavaScript. In the job script, use the following logic

	Code:
	Database.connect("profile name here"); var results = Databse.retrieve("SELECT column_name FROM my_table"); Database.disconnect(); var values = results.split("\r\n"); var i; for( i = 0; i < values.length - 1; i++) { // do here something with each value }

For more details on each script command and examples please see 24x7 JavaScript manual.

It works.. thank you.