Running custom scripts in Data Warehouse

Starting with OnCommand Insight 7.2.2, Data Warehouse allows customers to create jobs that can run custom scripts that prepare customized data in Data Warehouse.

Before you begin

To prevent the custom script from being deleted during a Data Warehouse upgrade, you must not store the script in the SANscreen directory.

About this task

The job can specify only one script. You can run multiple scripts and commands from one script.

Steps

  1. In Data Warehouse, select DWH Admin > Schedule.
  2. Select the Script enabled check box.
  3. Enter the absolute path of the script name in the Script Location text box.
  4. Click Save.

Result

The Data Warehouse job engine schedules the task to run a "Custom scripting" job. The job is scheduled to run after an ETL and avoiding other conflicting background processes. The job is not run by a "Build from history" operation.