OLD Creating a Schema V2.0
Open Studio
- Expand the Jobs node, right click on Unassigned tasks and select New Task.
- Create a Workflow Stored Procedure Task and give it a Name e.g. Create SDW Schema
- Select the Spatial Data Warehouse Connection, Click on the All radio button and select the Function astun.sdw_new_schema. From v6.0.0 select astun from the Function filter and pick sdw_new_schema
- Select the schemaname parameter and enter the name of your schema in the Edit parameter box. Then select the staffaccess parameter and enter true.
Note: Change "true" to "false" for a private schema. - Click the Run button to run the task. You should see the dialog SPTask 'Create SDW Schema' completed successfully. Click OK.
- Click Save to save your new task details.
- Your next step is to Assign Access Rights to the Schema.