HListScheduling (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

HFSQL Client/Server functions

HAddScheduledOptimization

HCS.FrameSize (Variable)

HCS.Timeout (Variable)

HDeleteScheduledBackup

HDeleteScheduledOptimization

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HInfoDatabaseRights (Example)

HInfoDatabaseRights

HInfoFileProperty

HInfoFileRights (Example)

HInfoServerRights (Example)

HListScheduledOptimization

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

HRestoreBackup (Example)

Necessary rights

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HListScheduling (Function)

In french: HListePlanification

Available only with this kind of connection

Lists the scheduled tasks defined on an HFSQL server:

stored procedure,
backup,
optimization,
refresh of materialized view.

Versions 22 and later

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

New in version 22

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

Example

// Modify all scheduled backups
arrBckDesc is array dynamic of hBackupDescription
arrBckDesc = HListScheduling(MyDatabaseConnection, hlpBackup)
hBckDesc is hBackupDescription
FOR EACH hBckDesc OF arrBckDesc
IF hBckDesc.LimitNumberBackups = 3 THEN
hBckDesc.LimitNumberBackups = 5
HModifyScheduling(MyDatabaseConnection, hBckDesc)
END
END

Syntax

<Result> = HListScheduling(<Connection> , <Type of scheduling>)

<Result>: Array

Array containing the listed descriptions. The type of the array elements depends on <Type of scheduling>.

<Connection>: Character string or Connection variable

Connection to use. This connection corresponds to:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.

<Type of scheduling>: Integer constant

Type of scheduling to list:
hlpBackup Scheduling of backups.
hlpMaterializedView Tasks for refreshing the materialized views.
hlpOptimization Tasks for optimizing data files (re-indexing, calculation of statistics).
hlpTask Scheduled tasks that run a stored procedure.

Remarks

Versions 23 and later

Necessary rights

To list the tasks for refreshing materialized views or scheduled tasks, it is necessary to have the connection rights (constant hRightsConnection or hRightsEncryptedConnection) for each database that contains a view to process or a stored procedure to run.

To find out whether these rights are granted to a user or group, use HInfoServerRights or HInfoDatabaseRights.

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

New in version 23

Necessary rights

To find out whether these rights are granted to a user or group, use HInfoServerRights or HInfoDatabaseRights.

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

Necessary rights

To find out whether these rights are granted to a user or group, use HInfoServerRights or HInfoDatabaseRights.

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

Component: wd270hf.dll