|
|
|
|
|
|
|
|
|
|
HFSQL Control Center: Refreshing materialized views
 Available only with this kind of connection
The Control Center allows you to implement a mechanism for regularly refreshing the content of a materialized view. In the HFSQL Control Center, refresh tasks for a materialized view can be defined at server or database level. To create a refresh task: - If necessary, connect to an HFSQL server and display the description of the server or one of its databases (double-click on the server or database name in the tree structure).
- Click the "Scheduled elements" tab.
- In the Ribbon, in the "Scheduled items" group, pull down "New schedule" and select "Schedule a materialized view refresh". The wizard for creating a scheduled materialized view refresh task is launched.
- Select the materialized views to be optimized:
- All database views,
- A selection of database views.
- Define task frequency: month, day, hour.
- Give your scheduled task a description and confirm the wizard.
- The scheduled refresh task appears in the "Scheduled items" tab of the HFSQL Control Center.
It is possible to delete, execute or modify the scheduled refresh task. To modify a scheduled refresh task: - If necessary, connect to an HFSQL server and display the appropriate server or database tab.
- Click the "Scheduled elements" tab.
- Select the materialized view refresh job to be modified.
- In the ribbon, in the "Scheduled elements" group, click "Edit".
You also have the ability to use the context menu of the scheduled element ("Edit" option). - A description window of the scheduled element is displayed. All features are grouped together on several tabs:
- Tab "General": Defines whether the view refresh task is active.
- Tab "Scheduling": Defines the scheduled optimization execution options (month, day, time).
 New in version 2025Tab "Execution History": This tab appears when the scheduled optimization has been executed automatically. This tab lists the different automation executions of the scheduled task, indicating: - the optimization start date,
- optimization status: completed, in progress, error,
- running time,
- the user who launched the optimization,
- if launched manually (via HExecuteScheduling).
- Validate.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|