HListScheduling (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Managing databases

HFSQL functions

HFSQL Client/Server functions

Prefix syntax

WLanguage procedure

HListScheduling

Presentation

Example

Necessary rights

See also

HAddGroup

HAddLink

HAddScheduledBackup

HAddScheduledOptimization

HAddScheduling

HAddTask

HAddUser

HBackup

HCS.FrameSize (Variable)

HCS.Timeout (Variable)

HCancelBackup

HChangePassword

HClearWorkingDir

HConnectionQuality

HCopyFile (Example)

HCopyFile

HDeleteBackup

HDeleteDatabase

HDeleteDirectory

HDeleteFile

HDeleteGroup

HDeleteLink

HDeleteParameter

HDeleteQuery

HDeleteScheduledBackup

HDeleteScheduledOptimization

HDeleteScheduling

HDeleteSet

HDeleteTask

HDeleteUser

HDisconnectClient

HDropView

HDuplicateDatabase

HEndNoDatabaseAccess

HExecuteProcedure

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HInfoDatabaseRights (Example)

HInfoDatabaseRights

HInfoFileProperty

HInfoFileRights (Example)

HInfoFileRights

HInfoGroup

HInfoLock

HInfoLog

HInfoServer

HInfoServerProperty

HInfoServerRights (Example)

HInfoServerRights

HInfoTask

HInfoUser

HInfoView

HInfoViewRights

HListConnectedUser

HListDatabase

HListGroup

HListParameter

HListScheduledBackup

HListScheduledOptimization

HListScheduling

HListServer

HListStoredElement

HListTask

HListUser

HLoadParameter

HManageTask

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HModifyServerRights

HModifyTask

HModifyUser

HModifyViewRights

HNoDatabaseAccess

HNotifAddCCRecipient

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

HOnServerCall

HOperationInProgress

HPriority

HPriorityClient

HReconnect

HResetClient

HResetGroup

HResetUser

HRestoreBackup (Example)

HRestoreBackup

HRetrieveBackup

HRetrieveLog

HSaveParameter

HSendMessageToClient

HServerMaintenance

HServerStatus

HServerWorkingDir

HSetCache

HSetServer

HSimulateNetwork

HStartServer

HStartServerUpdate

HStopServer

HSuggestKey

HSuggestKeyEnd

HSuggestKeyStart

HTrack

HTrackStop

HUpdateLink

HUpdateQuery

HUpdateSet

HUpdateView

hServerOperation

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.

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: wd270hf.dll