HListScheduling (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

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

Necessary rights

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HListScheduling (Function)

In french: HListePlanification

Available only with this kind of connection

Lists scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view.

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

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.

Component: wd300hf.dll