Create Task to add AddressBase View to Geometry columns

Now we need to add the AddressBase View to the Geometry columns. To do this you will need to add another Task entry. In the tree, right click on the Build My Addresses from AddressBase Job you have just created and select New Task.

Select the Stored Procedure type and click OK.

Name

Enter a name for the task e.g. Add AddressBase View to Geometry Columns.

Connection Details

Select the iShare database from the list. Then select the Workflow radio button as this will limit the list of available Functions and then select the at_wkf_executecmd entry from the list (from v6.0.0 this is called wkf_executecmd under the -Workflow- Function filter).

Select the Parameter No 1. in the list and paste the following into the Edit parameter 'cmdtoexecute' box.

Run the Task to add the AddressBase View to the Geometry Columns

Now we need to run the task to make sure that it works correctly.

Right click on the Task and select Run Add AddressBase View to Geometry Columns [or whatever you called the task].