HModifyScheduling (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

HModifyScheduling

Presentation

Example

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HModifyScheduling (Function)

In french: HModifiePlanification

Available only with this kind of connection

Modifies a scheduled task on an HFSQL server:

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

Example

// Describe the connection
MyDatabaseConnection is Connection

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

Modifying a scheduled task Hide the details

<Result> = HModifyScheduling(<Connection> , <Scheduled task>)

<Result>: Boolean

True if the scheduled task was modified,
False if an error occurred. HErrorInfo is used to identify the error.

<Connection>: Character string or Connection variable

Connection for which a scheduled task must be modified. 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.

<Scheduled task>: hScheduledTask variable

Name of hScheduledTask variable describing the task that triggers a stored procedure.

Modifying a scheduled optimization task Hide the details

<Result> = HModifyScheduling(<Connection> , <Scheduled optimization task>)

<Result>: Boolean

True if the scheduled optimization task was modified
False if an error occurred. HErrorInfo is used to identify the error.

<Connection>: Character string or Connection variable

Connection for which a scheduled optimization task must be modified. 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.

<Scheduled optimization task>: hScheduledOptimization variable

Name of the hScheduledOptimization variable used.

Modifying a backup scheduling Hide the details

<Result> = HModifyScheduling(<Connection> , <Scheduled backup>)

<Result>: Boolean

True if the scheduled backup was modified,
False otherwise.

<Connection>: Character string or Connection variable

Connection for which a scheduled backup must be modified. 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.

<Scheduled backup>: hBackupDescription variable

Name of the hBackupDescription variable used.

Modifying a scheduling for refreshing a materialized view Hide the details

<Result> = HModifyScheduling(<Connection> , <Materialized view>)

<Result>: Boolean

True if the scheduling was modified,
False otherwise.

<Connection>: Character string or Connection variable

Connection for which a materialized view refresh scheduling must be modified. 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.

<Materialized view>: hScheduleMaterializedView variable

Name of the hScheduleMaterializedView variable containing the description of the materialized views to refresh.

Component: wd280hf.dll