Adding Additional Batches to a Job

Note: This procedure is only needed for multiple batches.

Salesforce sets a limit on the amount of processing that it will do in one batch. You can break a data set up into multiple files and submit each file as a batch.

To add additional batches to a job:

  1. Run the create_job_batch job once to create the target file jobbatch.
  2. Right-click an application directory and select New, then Flow.
  3. Right-click the SQL object and select Add, then Join.
  4. Right-click the Join object and select Add, then Source.

    The Select synonym panel opens.

    Select addbatch and click Select.

  5. Right-click the Join object and select Add, then Source.

    The Select synonym panel opens. Select the target synonym for the create_job_batch flow, such as jobbatch, and click Select.

  6. Double-click the Inner Join object to open it. Under Left Source and Right Source, select JOBID and click the equal button, as shown in the following image.

    Click OK.

  7. Right-click the SQL object and select WHERE filter. Click the Relational Expression tab. Double-click FILE and select Variable for Type. Enter ‘&INFILE’ for the value. Double-click CONTTENTTYPE and enter ‘CVS’ for value. The expression should look like the following image.

    Click OK.

  8. Double-click the SQL object to open Column Selection. Double-click BATCHID under the OUTPUT and JOBBATCH columns. The Column Selection window should look like the following image. Click OK.

  9. Right-click the workspace to the right of the SQL object and select Add target, then New.
  10. Right-click the target object and select Properties.

    The target properties window opens.

  11. Select an available adapter, such as Delimited Flat file. Enter an application directory and synonym name, such as salesforce/jobbatch1.
  12. Enter a location for the table or file, such as salesforce/jobbatch1.ftm. Enter a comma (,) for the field delimiter and select Yes for the Header.
  13. Click the Save button. The Save Procedure dialog box opens. Enter a name, such as add_batch_request.

You can now run the flow specifying the file name for the new batch.

Repeat as necessary for each batch. Then run close_job.


WebFOCUS