<Connection variable>.ListScheduledOptimization (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

HFSQL Client/Server functions

Prefix syntax

ListScheduledOptimization

ActivateServerTrigger

AddGroup

AddLink

AddScheduledBackup

AddScheduledOptimization

DeactivateServerTrigger

DeleteScheduledBackup

DeleteScheduledOptimization

DescribeServerTrigger

ExecuteScheduledBackup

ListScheduledOptimization

ModifyDatabaseProperty

ModifyScheduledBackup

ModifyScheduledOptimization

NotifAddEmailRecipient

NotifConfigure

NotifDeleteCCRecipient

NotifDeleteEmailRecipient

NotifListCCRecipient

NotifListEmailRecipient

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.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 22 and later

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

New in version 22

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

Example

MyConnection is Connection
...
arrOptim is array of hScheduledOptimization
arrOptim = MyConnection.ListScheduledOptimization()
FOR EACH Optim OF arrOptim
DisplayInfo(Optim)
END

Syntax

<Result> = <Connection>.ListScheduledOptimization()

<Result>: Array of hScheduledOptimization variables

Array of hScheduledOptimization variable. 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

Versions 23 and later

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

New in version 23

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

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

Component : wd260hf.dll