|
|
|
|
|
|
|
|
|
|
- Properties specific to hScheduledOptimization variables
- Functions that handle the hScheduledOptimization type
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".
// 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 hScheduledOptimization variables: | | | | 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 hScheduledOptimization variables:
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|