|
|
|
|
|
<Variable Connexion>ListHistoryPlanning (Function) In french: <Connection variable>ListSchedulingHistory
Available only with this kind of connection
Lists the execution history of a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view). MyDatabaseConnection is Connection
IF NOT MyBaseConnection.PlanningHistoryList(MyPlannedTask) THEN
Trace(HErrorInfo())
END
Syntax
Lists the execution history of a backup schedule Hide the details
<Result> = <Connection>.ListHistoryPlanning([<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>: Connection variable Name of the Connection variable that describes the connection to use. <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 <Connection variable>.SetServer function, or via the HFCONF.INI file.
Lists the execution history of an optimization schedule Hide the details
<Result> = <Connection>.ListHistoryPlanning(<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>: Connection variable Name of the Connection variable that describes the connection to use. <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 <Connection variable>.SetServer function, or via the HFCONF.INI file.
Lists the execution history of a task scheduler Hide the details
<Result> = <Connection>.ListHistoryPlanning(<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>: Connection variable Name of the Connection variable that describes the connection to use. <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 <Connection variable>.SetServer function, or via the HFCONF.INI file.
Lists the execution history of a materialized view refresh schedule Hide the details
<Result> = <Connection>.ListHistoryPlanning(<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>: Connection variable Name of the Connection variable that describes the connection to use. <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 <Connection variable>.SetServer function, or via the HFCONF.INI file. Business / UI classification: Business Logic
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|