<Connection variable>.ListScheduledOptimization (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

Necessary rights

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.ListScheduledOptimization (Function)

In french: <Variable Connexion>.ListeOptimisationPlanifiée

Available only with this kind of connection

Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.

Example

MaConnexion is Connection
...
tabOptim is array of hScheduledOptimization
tabOptim = MaConnexion.ListeOptimisationPlanifiée()
FOR EACH Optim OF tabOptim
	AfficheInfo(Optim)
END

Syntax

<Result> = <Connection>.ListScheduledOptimization()

<Result>: Array of hScheduledOptimization variables

Array of a variable of type hScheduledOptimization. Each element found in this array contains the characteristics of a scheduled optimization task. The number of elements in this array corresponds to the number of available scheduled optimization tasks.

<Connection>: Connection variable

Name of the Connection variable that describes the connection for which the scheduled optimization tasks must be listed.

Remarks

Necessary rights

To list the scheduled optimization tasks, you must have the rights to connect (hRightsConnection or hRightsEncryptedConnection constant) to each relevant database,

For a full server optimization, the user must be a super-user.

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 group of users, use <Connection variable>.ModifyServerRights or <Connection variable>.ModifyDatabaseRights.

Component: wd300hf.dll