<Connection variable>.AddScheduling (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

HFSQL Client/Server functions

ActivateServerTrigger

AddGroup

AddLink

AddScheduledBackup

AddScheduledOptimization

DeactivateServerTrigger

DeleteScheduledBackup

DeleteScheduledOptimization

DescribeServerTrigger

ExecuteScheduledBackup

ListScheduledOptimization

ModifyDatabaseProperty

ModifyScheduledBackup

ModifyScheduledOptimization

NotifAddEmailRecipient

NotifConfigure

NotifDeleteCCRecipient

NotifDeleteEmailRecipient

NotifListCCRecipient

NotifListEmailRecipient

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.AddScheduling (Function)

In french: <Variable Connexion>.AjoutePlanification

Available only with this kind of connection

Creates a scheduled task on a HFSQL server:

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

Versions 22 and later

This function is now available in Universal Windows 10 App mode.

New in version 22

This function is now available in Universal Windows 10 App mode.

Example

// Describe the connection
MyConnection is Connection
...
// 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

MyConnection.AddScheduling(Optim)

Syntax

Adding a scheduled task Hide the details

<Result> = <Connection>.AddScheduling(<Scheduled task>)

<Result>: Boolean

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

<Connection>: Connection variable

Name of the Connection variable that describes the connection for which a scheduled task must be added.

<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> = <Connection>.AddScheduling(<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>: Connection variable

Name of the Connection variable that describes the connection for which a scheduled optimization task must be added.

<Scheduled optimization task>: hScheduledOptimization variable

Name of the hScheduledOptimization variable used.

Adding a backup scheduling Hide the details

<Result> = <Connection>.AddScheduling(<Scheduled backup>)

<Result>: Boolean

True if the scheduled backup was added,
False otherwise.

<Connection>: Connection variable

Name of the Connection variable that describes the connection for which a scheduled backup must be added.

<Scheduled backup>: hBackupDescription variable

Name of the hBackupDescription variable used.

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

<Result> = <Connection>.AddScheduling(<Materialized view>)

<Result>: Boolean

True if the scheduling was added,
False otherwise.

<Connection>: Connection variable

Name of the Connection variable that describes the connection for which a materialized view refresh scheduling must be added.

<Materialized view>: hScheduleMaterializedView variable

Name of the hScheduleMaterializedView variable that contains the description of the materialized view to refresh.

Component : wd260hf.dll