|
|
|
|
|
|
|
|
|
|
- Properties specific to hScheduledOptimization variables
- Functions that use the hScheduledOptimization type
hScheduledOptimization (Variable type) 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 using various WLanguage properties. Note: For more details on the declaration of this type of variable and the use of WLanguage properties, see "Declaring a variable".
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)
Properties 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. |
Remarks Functions that use the hScheduledOptimization type The following functions can be used to handle hScheduledOptimization variables:
| | | HAddScheduledOptimization | Adds an optimization task of HFSQL Client/Server data files. | | 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. | | HExecuteScheduling | Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. | | Lists the execution history of a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view). | | HModifyScheduledOptimization | Modifies a scheduled optimization task on the HFSQL server defined by the connection. | | HModifyScheduling | Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. | | Deletes the execution history of a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.). |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|