HExecuteScheduling (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

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

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.

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

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 (with or without quotes) 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 Connection variable.

<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 (with or without quotes) 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 Connection variable.

<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 (with or without quotes) 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 Connection variable.

<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 (with or without quotes) 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 Connection variable.

<Materialized view>: hScheduleMaterializedView variable

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

Component : wd250hf.dll