List of Data Warehouse Jobs
Data Warehouse Jobs
Data Warehouse Job | What it does | When to run |
---|---|---|
WH_install |
Installs the Data Warehouse. It builds the schema objects (tables, views, indexes..etc.) |
If you don't have Data Warehouse installed for TeamConnect instance. You can run this job to install the Data Warehouse. You also need to run this job when there is a change in TeamConnect design, such as adding a new custom field or object, delete or edit existing custom field or object. |
WH_remove | Uninstall the Data Warehouse for the TeamConnect instance. | Uninstall the Data Warehouse for TeamConnect instance. |
WH_upgrade | Upgrades to the higher version of Data Warehouse. | Execute this job to upgrade the Data Warehouse to the higher version. |
TeamConnect_Warehouse_initial | All the tables will be loaded with data. | Usually we run this job after the install to load the data. |
TeamConnect_Warehouse_initial_cf |
Running this will add custom fields to Data Warehouse. Running this will reload all the custom fields tables (WHCC_* and WHCF_* tables). |
Running this will add custom fields to Data Warehouse. Run this when there is a change from non-reportable to reportable in an existing custom field. |
TeamConnect_Warehouse_Refresh |
To perform install (bring new design changes from TC to DW) then load the incremental data from TeamConnect into the Data Warehouse.
|
Execute this job to load the incremental data on demand to the Data Warehouse when any design changes are made in TeamConnect. For example, if you add/remove custom objects/custom fields in TeamConnect instance then execute this job. |
TeamConnect_Warehouse_Refresh_no_install |
To load the incremental data from TeamConnect into the Data Warehouse. |
Execute this job to load the incremental data on demand to the Data Warehouse if no design changes are made in TeamConnect. |
TeamConnect_Warehouse_Refresh_resume |
If the load incremental data load is failed or paused, execute this job to resume from the point where it failed or stopped. |
To resume the incremental data load from the point where it failed or stopped. |