hScheduleMaterializedView (Variable type)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / Types of HFSQL variables

Properties specific to hScheduleMaterializedView variables
Functions that are using the hScheduleMaterializedView variables:

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

hScheduleMaterializedView (Variable type)

In french: hPlanificationVueMatérialisée

The hScheduleMaterializedView type is used to programmatically manage a task for recalculating the data of a scheduled materialized view on an HFSQL server.
You can define and change the characteristics of this task using different WLanguage properties.

Remarks:

For more details on materialized views, see Materialized view.
For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.

Example

// Refresh the materialized views every Saturday at 23:00
refreshView is hScheduleMaterializedView
refreshView.Description = "View data recalculation"

// Characteristics of the scheduling
refreshView.Scheduling.Month = "*"
refreshView.Scheduling.DayOfWeek = "Saturday"
refreshView.Scheduling.Hour = "23"
refreshView.Scheduling.Minute = "0"

// Add the materialized view to refresh

// Syntax 1: 
// Refreshes all the materialized views of "MyDatabase"
refreshView.View[1] = "MyDatabase" 

// Syntax 2: 
// Refreshes "MyView" of "MyDatabase"
refreshView.View[1] = "MyDatabase/MyView" 

HAddScheduling(cnt, refreshView)

Properties

Properties specific to hScheduleMaterializedView variables

The following properties can be used to handle a task for recalculating the data of a materialized view:

Property name	Type used	Effect

Description	Character string	Description associated with the data recalculation task of a materialized view.
Enabled	Boolean	True if the data recalculation scheduling is enabled, False otherwise.
Identifier	Integer	Identifier of the data recalculation task of materialized views. This property is read-only.
Scheduling	hScheduling variable	Characteristics of the scheduling to be established to recalculate the content of materialized views.
User	Character string	User who created the materialized view recalculation scheduling task. This property is read-only.
View	Array of strings	List of materialized views whose task will recalculate the content. These views have been created: in the data model editor, via the SQL "CREATE MATERIALIZED VIEW" command. To refresh all the materialized views of "MyDatabase", the syntax is as follows: refreshView.View[1] = "MyDatabase" To refresh "MyView" of "MyDatabase", the syntax is as follows: refreshView.View[1] = "MyDatabase/MyView"

Remarks

Functions that are using the hScheduleMaterializedView variables:


HAddScheduling	Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view.
HDeleteScheduling	Delete a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.
New in version 2025 HDeleteSchedulingHistory	Deletes the executions of a scheduled job on an HFSQL server. This job can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh.
HExecuteScheduling	Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.
New in version 2025 HListSchedulingHistory	Lists the executions of a scheduled job on an HFSQL server. This job can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh.
HModifyScheduling	Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.