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

HExecuteScheduling

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

HExecuteScheduling (Function)

In french: HExécutePlanification

Available only with this kind of connection

Immediately runs a scheduled task regardless of its schedule:

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

Example

arrBckDesc is array dynamic of hBackupDescription
arrBckDesc = HListScheduling(MyDatabaseConnection, hlpBackup)
hBckDesc is hBackupDescription
FOR EACH hBckDesc OF arrBckDesc
HExecuteScheduling(MyDatabaseConnection, hBckDesc)
END

Syntax

Running a scheduled task immediately Hide the details

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

<Result>: Boolean

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

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

<Scheduled task>: hScheduledTask variable

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

Running a scheduled optimization task Hide the details

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

<Result>: Boolean

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

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

<Scheduled optimization task>: hScheduledOptimization variable

Name of the hScheduledOptimization variable used.

Running a backup scheduling Hide the details

<Result> = HExecuteScheduling(<Connection> , <Scheduled backup> [, <Type of backup>])

<Result>: Boolean

True if the scheduled backup was run,
False otherwise.

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

<Scheduled backup>: hBackupDescription variable

Name of the hBackupDescription variable used.

<Type of backup>: Optional boolean

Type of backup to perform:
True (default value): Differential backup.
False: Full backup.
Remark: A differential backup can be performed only if the backup task includes a differential scheduling.

Running a scheduling used to refresh a materialized view Hide the details

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

<Result>: Boolean

True if the scheduling was run,
False otherwise.

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

<Materialized view>: hScheduleMaterializedView variable

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

Component: wd280hf.dll