PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
  • Necessary rights
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
<Connection variable>.AddScheduledOptimization (Function)
In french: <Variable Connexion>.AjouteOptimisationPlanifiée
HFSQL Client/ServerAvailable only with this kind of connection
Adds an optimization task of HFSQL Client/Server data files.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 22
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Example
// Describe the connection
MyConnection is Connection
...
// 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" + ...
" in  MyDatabase"
 
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
 
MyConnection.AddScheduledOptimization(Optim)
Syntax
<Result> = <Connection>.AddScheduledOptimization(<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>: Connection variable
Name of the Connection variable that describes the connection for which a scheduled optimization task must be added.
<Scheduled optimization task>: hScheduledOptimization variable
Name of hScheduledOptimization variable used.
Remarks

Necessary rights

To add a scheduled optimization task, you must have:
  • the corresponding rights (hRightsManageTask constant) on the server,
  • Versions 23 and later
    the rights to connect (hRightsConnection or hRightsEncryptedConnection) to each relevant database,
    New in version 23
    the rights to connect (hRightsConnection or hRightsEncryptedConnection) to each relevant database,
    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.
Versions 23 and later
For a full server optimization, the user must be a super-user.
New in version 23
For a full server optimization, the user must be a super-user.
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.
To find out whether these rights are granted to a user or to a group, use <Connection variable>.InfoServerRights or <Connection variable>.InfoDatabaseRights.
To modify the rights granted to a user or to a group of users, use <Variable Connexion>.ModifieDroitServeur or <Variable Connexion>.ModifieDroitBaseDeDonnées.
Component : wd250hf.dll
See also
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment