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

HAddScheduling

Presentation

Example

See also

HAddGroup

HAddLink

HAddScheduledBackup

HAddScheduledOptimization

HAddScheduling

HAddTask

HAddUser

HBackup

HCS.FrameSize (Variable)

HCS.Timeout (Variable)

HCancelBackup

HChangePassword

HCheckServerUpdate

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

HManageServerUpdate

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

HTransactionRollbackToSavepoint

HTransactionSavepoint

HUpdateLink

HUpdateQuery

HUpdateSet

HUpdateView

hServerOperation

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HAddScheduling (Function)

In french: HAjoutePlanification

Available only with this kind of connection

Creates a scheduled task on an HFSQL server:

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

Example

// Recalculate statistics of data files in "MyDatabase",
// every Saturday at 23:00
Optim is hScheduledOptimization
Optim.Description = "Recalculating statistics of data files" + ...
" in MyDatabase"

Optim.Scheduling.Month = "*"
Optim.Scheduling.DayOfWeek = "Saturday"
Optim.Scheduling.Hour = "23"
Optim.Scheduling.Minute = "0"

Optim.File[1].Name = "MyDatabase"
Optim.File[1].Option = hOptStat

HAddScheduling(MyConnection, Optim)

Syntax

Adding a scheduled task Hide the details

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

<Result>: Boolean

True if the scheduled task was added,
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 added. 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.

Adding a scheduled optimization task Hide the details

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

<Result>: Boolean

True if the scheduled optimization task was added,
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 will be added. 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.

Adding a backup scheduling Hide the details

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

<Result>: Boolean

True if the scheduled backup was added,
False otherwise.

<Connection>: Character string or Connection variable

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

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

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

<Result>: Boolean

True if the scheduling was added,
False otherwise.

<Connection>: Character string or Connection variable

Connection for which a materialized view refresh scheduling must be added. 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 that contains the description of the materialized view to refresh.

Component: wd280hf.dll