HAddScheduledOptimization (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

WLanguage

Management of databases

HFSQL functions

HFSQL Client/Server functions

HAddScheduledOptimization

HAddScheduledOptimization

HCS.Timeout (Variable)

HDeleteScheduledBackup

HDeleteScheduledOptimization

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HListScheduledOptimization

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

Necessary rights

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HAddScheduledOptimization (Function)

In french: HAjouteOptimisationPlanifiée

Available only with this kind of connection

Adds an optimization task of HFSQL Client/Server data files.

Note: 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

// 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

HAddScheduledOptimization(MyConnection, Optim)

Syntax

<Result> = HAddScheduledOptimization(<Connection name> , <Name of the 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 name>: Character string (with or without quotes)

Name of connection for which a scheduled optimization task will be added. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.

<Name of the 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.

Note: 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 HInfoServerRights or HInfoDatabaseRights.

To modify the rights granted to a user or to a group of users, use HModifyServerRights or HModifyDatabaseRights.

Component : wd240hf.dll