Decisions Example 3: Starting Multiple Batch Jobs
This decision executes a USoft Batch job for each pending project from within an online application by retrieving project codes that correspond to an on-screen value. Typically, the Scheduled flag will be set to 'N' by a SQL task at the end of the batch job. The batch job could be an export job, in which case the decision could be called from a "Generate Updated Flat Files" menu option.
FROM project p , destination d
WHERE p.destination = d.destination
AND d.destination_id = :"query.destination_id()"
AND p.scheduled = 'Y'
ActionStartJob('PROJECT_PROGRESS_REPORT', FORMULA(':1 || :2', *'PROJECT_CODE=', :1))
The job is started as many times as there are rows retrieved by the Decision SQL statement. For each row, the retrieved project_code is passed to the job as a parameter.
MessageInformation('No jobs scheduled at this time.')