HAddScheduling (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

HFSQL Client/Server functions

HAddScheduledOptimization

HCS.FrameSize (Variable)

HCS.Timeout (Variable)

HDeleteScheduledBackup

HDeleteScheduledOptimization

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HListScheduledOptimization

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

This content has been translated automatically. Click here to view the French version.

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.

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

// Recalculer les statistiques des fichiers de données de la base de données "MaBase",
// tous les samedis à 23H00
Optim is hScheduledOptimization
Optim.Description = "Recalcul des statistiques des fichiers de données" + ...
" de la base de données MaBase"

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

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

HAddScheduling(MaConnexion, 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>: String or Variable of type Connection

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>: String or Variable of type Connection

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 Variable of type hScheduledOptimization handled.

Adding a backup scheduling Hide the details

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

<Result>: Boolean

True if the scheduled backup was added,
False otherwise.

<Connection>: String or Variable of type Connection

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 Variable of type hBackupDescription handled.

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>: String or Variable of type Connection

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