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.
- Right-click an application directory and select New, then Flow.
- Right-click the SQL object and select Add,
then Join.
- Right-click the Join object and select Add,
then Source.
The Select synonym panel
opens.
Select closejob and click Select.
- 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.
- Double-click the Join object to open it. Under Left source and
Right source, select JOBID. Click the button and click OK.
- 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.
- Right-click the workspace to the right of the SQL object and
select Add Target, then New.
- Right-click the target object and select Properties.
The
target properties window opens.
- Select an available adapter, such as Delimited Flat
file. Enter an application directory and synonym name,
such as salesforce/checkresp.
- 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.
- 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.