|
|
|
|
|
|
|
|
|
|
<Connection variable>.ListSchedulingHistory (Function) In french: <Variable Connexion>.ListeHistoriquePlanification
 Available only with this kind of connection
Lists the executions of a scheduled job on an HFSQL server. This job can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh. MyDatabaseConnection is Connection
MyArray is array of hSchedulingHistory
MyArray = MyDatabaseConnection.ListSchedulingHistory(MyScheduledTask)
IF ErrorOccurred = True THEN
Trace(HErrorInfo())
END
Syntax
Listing the execution history of a scheduled backup Hide the details
<Result> = <Connection>.ListSchedulingHistory([<Scheduled backup> [, <Number of elements>]])
<Result>: Array of hSchedulingHistory variables Array of hSchedulingHistory variables, corresponding to the different executions of the scheduled backup. <Connection>: Connection variable Name of the Connection variable that describes the connection to use. <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 <Connection variable>.SetServer function, or in the HFCONF.INI file.
Listing the execution history of a scheduled optimization Hide the details
<Result> = <Connection>.ListSchedulingHistory(<Scheduled optimization> [, <Number of elements>])
<Result>: Array of hSchedulingHistory variables Array of hSchedulingHistory variables, corresponding to the different executions of the scheduled optimization. <Connection>: Connection variable Name of the Connection variable that describes the connection to use. <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 <Connection variable>.SetServer function, or in the HFCONF.INI file.
Listing the execution history of a scheduled task Hide the details
<Result> = <Connection>.ListSchedulingHistory(<Scheduled task> [, <Number of elements>])
<Result>: Array of hSchedulingHistory variables Array of hSchedulingHistory variables, corresponding to the different executions of the scheduled task. <Connection>: Connection variable Name of the Connection variable that describes the connection to use. <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 <Connection variable>.SetServer function, or in the HFCONF.INI file.
Listing the execution history of a scheduled refresh of a materialized view Hide the details
<Result> = <Connection>.ListSchedulingHistory(<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>: Connection variable Name of the Connection variable that describes the connection to use. <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 <Connection variable>.SetServer function, or in the HFCONF.INI file. Business / UI classification: Business Logic
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|