hScheduledOptimization (Type of variable)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Managing databases

HFSQL functions

Types of HFSQL variables

hScheduledOptimization

Presentation

Example

Properties specific to hScheduledOptimization variables

Functions that handle the hScheduledOptimization type

See also

hScheduledOptimization (Type of variable)

In french: hOptimisationPlanifiée

Available only with this kind of connection

The hScheduledOptimization type is used to programmatically manage a scheduled optimization task on an HFSQL server. A scheduled optimization task periodically performs statistical calculations or reindexes the data files on the HFSQL server.

The characteristics of this scheduled optimization task can be defined and modified by several WLanguage properties.

Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see "Declaring a variable".

Example

// Recalculate the statistics for the files found in "MyDatabase" every Saturday at 23:00
Optim is hScheduledOptimization
Optim.Description = "Recalculating the statistics for the files found in the MyDatabase database"

Optim.Scheduling.Month = "*"
Optim.Scheduling.DayOfWeek = "Saturday"
Optim.Scheduling.Hour = "23"
Optim.Scheduling.Minute = "0"

Optim.File[1].Name = "MyDatabase"
Optim.File[1].Option = hOptStat

HAddScheduledOptimization(MyConnection, Optim)

Remarks

Properties specific to hScheduledOptimization variables

The following properties can be used to handle a hScheduledOptimization variable:

Property name	Type used	Effect

Description	Character string	Text describing the scheduling of the optimization. The description of the optimization scheduling corresponds to an empty string ("") by default.
Enabled	Boolean	True if the scheduling of the optimization is enabled, False otherwise.
File	Array of hFileParameter variables	Description of the files that must be taken into account during the optimization.
Identifier	Integer	Identifier of the optimization task. This property is read-only.
NumberExecution	Integer	Number of times the task for optimization scheduling must be run. This property can also correspond to the Infinite constant.
Scheduling	hScheduling variable	Characteristics of the scheduling.
User	Character string	User who created the task for optimization scheduling. This property is read-only.

Functions that handle the hScheduledOptimization type

The following functions can be used to handle a hScheduledOptimization variable:


HAddScheduledOptimization	Adds an optimization task of HFSQL Client/Server data files.
HListScheduledOptimization	Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
HModifyScheduledOptimization	Modifies a scheduled optimization task on the HFSQL server defined by the connection.