ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

New WINDEV, WEBDEV and WINDEV Mobile 2025 feature!
This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Lists the execution history of a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view).
Example
IF NOT HListSchedulingHistory(MaConnexionBase, MaTachePlanifiée) THEN
	Trace(HErrorInfo())
END
Syntax

Lists the execution history of a backup schedule Hide the details

<Result> = HListHistoryPlanning(<Connection> [, <Backup scheduling> [, <Number of elements>]])
<Result>: Array of variables of type hHistoryPlanning
Array of variables of type hHistoryPlanning, corresponding to the different executions of the scheduled backup.
<Connection>: Character string or Connection variable
Connection to use. This connection corresponds to:
<Backup scheduling>: Variable of type hDescriptionSave optional
Name of variable of type hBackupDescription for which history is to be listed. If this parameter is not specified, the result will be the execution history of all backup schedules defined for the connection.
<Number of elements>: Optional integer
Maximum number of history items to list.
Note: By default, 100,000 items are stored in the history. It is possible to modify this limit either with the HSetServer function, or via the HFCONF.INI file.

Lists the execution history of an optimization schedule Hide the details

<Result> = HListHistoryPlanning(<Connection> , <Optimization planning> [, <Number of elements>])
<Result>: hHistoryPlanning variable array
Array of variables of type hHistoryPlanning, corresponding to the different executions of the planned optimization.
<Connection>: Character string or Connection variable
Connection to use. This connection corresponds to:
<Optimization planning>: hScheduledOptimization variable
Name of variable of type hScheduledOptimization for which history is to be listed. If this parameter is not specified, the result will be the execution history of all backup schedules defined for the connection.
<Number of elements>: Optional integer
Maximum number of history items to list.
Note: By default, 100,000 items are stored in the history. It is possible to modify this limit either with the HSetServer function, or via the HFCONF.INI file.

Lists the execution history of a task scheduler Hide the details

<Result> = HListHistoryPlanning(<Connection> , <Task scheduler> [, <Number of elements>])
<Result>: hHistoryPlanning variable array
Array of variables of type hHistoryPlanning, corresponding to the different executions of the scheduled task.
<Connection>: Character string or Connection variable
Connection to use. This connection corresponds to:
<Task scheduler>: hScheduledTask variable
Name of variable of type hScheduledTask for which history is to be listed. If this parameter is not specified, the result will be the execution history of all backup schedules defined for the connection.
<Number of elements>: Optional integer
Maximum number of history items to list.
Note: By default, 100,000 items are stored in the history. It is possible to modify this limit either with the HSetServer function, or via the HFCONF.INI file.

Lists the execution history of a materialized view refresh schedule Hide the details

<Result> = HListHistoryPlanning(<Connection> , <Planning a materialized view> [, <Number of elements>])
<Result>: hHistoryPlanning variable array
Array of variables of type hHistoryPlanning, 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:
<Planning a materialized view>: hScheduleMaterializedView variable
Name of variable of type hScheduleMaterializedView for which history is to be listed. If this parameter is not specified, the result will be the execution history of all backup schedules defined for the connection.
<Number of elements>: Optional integer
Maximum number of history items to list.
Note: By default, 100,000 items are stored in the history. It is possible to modify this limit either with the HSetServer function, or via the HFCONF.INI file.
Business / UI classification: Business Logic
Component: wd300hf.dll
Minimum version required
  • Version 2025
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 10/19/2024

Send a report | Local help