HAddScheduling (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

WLanguage

Management of databases

HFSQL functions

HFSQL Client/Server functions

HAddScheduledOptimization

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HAddScheduling (Function)

In french: HAjoutePlanification

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

// Recalculate the statistics for the files found in "MyDatabase",
// every Saturday at 23:00
Optim is hScheduledOptimization
Optim..Description = "Recalculating the statistics for the 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 name> , <Scheduled task>)

<Result>: Boolean

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

<Connection name>: Character string (with or without quotes)

Name of connection for which a scheduled task will be added. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.

<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 name> , <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 name>: Character string (with or without quotes)

Name of connection for which a scheduled optimization task will be added. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.

<Scheduled optimization task>: hScheduledOptimization variable

Name of hScheduledOptimization variable used.

Adding a backup scheduling Hide the details

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

<Result>: Boolean

True if the scheduled backup was added,
False otherwise.

<Connection name>: Character string (with or without quotes)

Name of connection for which a scheduled backup will be added. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.

<Scheduled backup>: hBackupDescription variable

Name of hBackupDescription variable used.

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

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

<Result>: Boolean

True if the scheduling was added,
False otherwise.

<Connection name>: Character string (with or without quotes)

Name of the connection for which a refresh scheduling must be added. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.

<Materialized view>: hScheduleMaterializedView variable

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

Component : wd240hf.dll