|
|
|
|
|
HAddScheduledOptimization (Function) In french: HAjouteOptimisationPlanifiée
Available only with this kind of connection
Adds an optimization task of HFSQL Client/Server data files.
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)
Syntax
<Result> = HAddScheduledOptimization(<Connection> , <Scheduled optimization task>)
<Result>: Boolean - True if the scheduled optimization task was added
- False if an error occurred. HErrorInfo is used to identify the error.
<Connection>: Character string or Connection variable Connection for which a scheduled optimization task will be added. This connection corresponds to: <Scheduled optimization task>: hScheduledOptimization variable Name of the hScheduledOptimization variable used. Remarks Necessary rights To add a scheduled optimization task, you must have: - the corresponding rights (hRightsManageTask constant) on the server,
- the rights to connect (hRightsConnection or hRightsEncryptedConnection) to each relevant database,
- the rights to run the command linked to the scheduled optimization task.
The task will be run with the account of user who created the task. For a full server optimization, the user must be a super-user. Remark: The schedule optimization task will not be performed if the server is switched off. The scheduled optimization task will be performed at the next available date when the server is switched on.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|