After you have submitted all the batches for a job, the job should be closed. Once the job is closed no more batches can be added. A job will eventually time out if you do not close it.

1. Right-click an application directory and select New, then Flow.
2. Right-click the SQL object and select Add, then Join.
3. Right-click the Join object and select Add, then Source.

   The Select synonym panel opens.

   Select closejob and click Select.

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

   The Select synonym panel opens.

   Select the target synonym for the flow you created to load data, such as jobbatch and click Select.

5. Double-click the Join object to open it. Under Left source and Right source, select JOBID. Click the button and click OK.
6. Double-click the SQL object.

   The Column Selection window opens. Double-click the CLOSE_JOB_RESPONSE field to select it. Click OK to close it.

7. Right-click the workspace to the right of the SQL object and select Add Target, then New.
8. Right-click the target object and select Properties.

   The target properties window opens.

9. Select an available adapter, such as Delimited Flat file. Enter an application directory and synonym name, such as salesforce/checkresp.
10. Enter a location for the table or file, such as salesforce/checkresp.ftm. Enter a comma (,) for the field delimiter and select Yes for the Header.
11. Click the Save button to save the flow.

    The Save Procedure as window opens.

    Enter a name for the flow, such as close_job. Click Save.