hScheduledOptimization (Type of variable)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Properties specific to the description of hScheduledOptimization variables
Functions that handle the hScheduledOptimization type

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

hScheduledOptimization (Type of variable)

In french: hOptimisationPlanifiée

Available only with this kind of connection

The hScheduledOptimization type is used to manage a scheduled optimization task on a HFSQL server by programming. A scheduled optimization task is used to periodically perform statistical calculations or to reindex the data files found on the HFSQL server.

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

Remark: See "Declaring a variable" for more details on the declaration of this type of variable and the use of WLanguage properties.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

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 the description of hScheduledOptimization variables

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

Property name	Type used	Effect

Enabled	Boolean	True if the scheduling of the optimization is enabled, False otherwise.
Description	Character string	Text describing the scheduling of the optimization. The description of the optimization scheduling corresponds to an empty string ("") by default.
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 available in 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.

Remark: These properties can be used with one of the following syntaxes:

<Variable name>..<Property name>
<Variable name>.<Property name>

Functions that handle the hScheduledOptimization type

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


Versions 15 and later HAddScheduledOptimization New in version 15 HAddScheduledOptimization HAddScheduledOptimization	Adds an optimization task of HFSQL Client/Server data files.
Versions 15 and later HListScheduledOptimization New in version 15 HListScheduledOptimization HListScheduledOptimization	Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
Versions 15 and later HModifyScheduledOptimization New in version 15 HModifyScheduledOptimization HModifyScheduledOptimization	Modifies a scheduled optimization task on the HFSQL server defined by the connection.