HListSchedulingHistory (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

HListSchedulingHistory (Function)

In french: HListeHistoriquePlanification

Available only with this kind of connection

Lists 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 HListSchedulingHistory(MyDatabaseConnection, MyScheduledTask) THEN
	Trace(HErrorInfo())
END

Syntax

Listing the execution history of a scheduled backup Hide the details

<Result> = HListSchedulingHistory(<Connection> [, <Scheduled backup> [, <Number of elements>]])

<Result>: Array of hSchedulingHistory variables

Array of hSchedulingHistory variables, corresponding to the different executions of the scheduled backup.

<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>: Optional hBackupDescription variable

Name of the hBackupDescription variable for which history is to be listed. If this parameter is not specified, the result will be the execution history of all scheduled backups defined for the connection.

<Number of elements>: Optional integer

Maximum number of history entries to list.
Note: By default, the history contains up to 100,000 entries. You can change this value using the HSetServer function, or in the HFCONF.INI file.

Listing the execution history of a scheduled optimization Hide the details

<Result> = HListSchedulingHistory(<Connection> , <Scheduled optimization> [, <Number of elements>])

<Result>: Array of hSchedulingHistory variables

Array of hSchedulingHistory variables, corresponding to the different executions of the scheduled optimization.

<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>: hScheduledOptimization variable

Name of the hScheduledOptimization variable for which history is to be listed. If this parameter is not specified, the result will be the execution history of all scheduled backups defined for the connection.

<Number of elements>: Optional integer

Maximum number of history entries to list.
Note: By default, the history contains up to 100,000 entries. You can change this value using the HSetServer function, or in the HFCONF.INI file.

Listing the execution history of a scheduled task Hide the details

<Result> = HListSchedulingHistory(<Connection> , <Scheduled task> [, <Number of elements>])

<Result>: Array of hSchedulingHistory variables

Array of hSchedulingHistory variables, corresponding to the different executions of the scheduled task.

<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 for which history is to be listed. If this parameter is not specified, the result will be the execution history of all scheduled backups defined for the connection.

<Number of elements>: Optional integer

Maximum number of history entries to list.
Note: By default, the history contains up to 100,000 entries. You can change this value using the HSetServer function, or in the HFCONF.INI file.

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

<Result> = HListSchedulingHistory(<Connection> , <Scheduled materialized view> [, <Number of elements>])

<Result>: Array of hSchedulingHistory variables

Array of hSchedulingHistory variables, corresponding to the different executions of the scheduled refresh of a materialized view.

<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 materialized view>: hScheduleMaterializedView variable

Name of the hScheduleMaterializedView variable for which history is to be listed. If this parameter is not specified, the result will be the execution history of all scheduled backups defined for the connection.

<Number of elements>: Optional integer

Maximum number of history entries to list.
Note: By default, the history contains up to 100,000 entries. You can change this value using the HSetServer function, or in the HFCONF.INI file.

Business / UI classification: Business Logic

Component: wd300hf.dll