HDeleteSchedulingHistory (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

New WINDEV, WEBDEV and WINDEV Mobile 2025 feature!

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HDeleteSchedulingHistory (Function)

In french: HSupprimeHistoriquePlanification

Available only with this kind of connection

Deletes the executions of a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh.

Example

IF NOT HDeleteSchedulingHistory(MyDatabaseConnection, MyScheduledTask) THEN
	Trace(HErrorInfo())
END

Syntax

Deleting the history of a scheduled backup Hide the details

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

<Result>: Boolean

True if the history was deleted,
False if an error occurs. HErrorInfo is used to identify the error.

<Connection>: Character string 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 variable of type Connection.

<Scheduled backup>: hBackupDescription variable

Name of the hBackupDescription variable used.

Deleting the history of a scheduled optimization task Hide the details

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

<Result>: Boolean

True if the history was deleted,
False if an error occurs. HErrorInfo is used to identify the error.

<Connection>: Character string 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 variable of type Connection.

<Scheduled optimization task>: hScheduledOptimization variable

Name of the hScheduledOptimization variable used.

Deleting the history of a scheduled task Hide the details

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

<Result>: Boolean

True if the history was deleted,
False if an error occurs. HErrorInfo is used to identify the error.

<Connection>: Character string 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 variable of type Connection.

<Scheduled task>: hScheduledTask variable

Name of the hScheduledTask variable to be used.

Deleting the execution history of a scheduled refresh of a materialized view Hide the details

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

<Result>: Boolean

True if the history was deleted,
False if an error occurs. HErrorInfo is used to identify the error.

<Connection>: Character string 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 variable of type Connection.

<Materialized view>: hScheduleMaterializedView variable

Name of the hScheduleMaterializedView variable to be used.

Business / UI classification: Business Logic

Component: wd300hf.dll