|
|
|
|
|
|
|
|
|
|
<Connection variable>.ListScheduling (Function) In french: <Variable Connexion>.ListePlanification
 Available only with this kind of connection
Lists scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view. // Describe the connection
MyDatabaseConnection is Connection
// Modify all scheduled backups
arrBckDesc is array dynamic of hBackupDescription
arrBckDesc = MyDatabaseConnection.ListScheduling(hlpBackup)
hBckDesc is hBackupDescription
FOR EACH hBckDesc OF arrBckDesc
IF hBckDesc.LimitNumberBackups = 3 THEN
hBckDesc.LimitNumberBackups = 5
MyDatabaseConnection.ModifyScheduling(hBckDesc)
END
END
Syntax
<Result> = <Connection>.ListScheduling(<Type of scheduling>)
<Result>: Array Array containing the listed descriptions. The type of the array elements depends on <Type of scheduling>. <Connection>: Connection variable Name of the Connection variable that describes the connection to use. <Type of scheduling>: Integer constant Type of scheduling to list: | | | hlpBackup | Scheduling of backups. | | hlpMaterializedView | Tasks for refreshing the materialized views. | | hlpOptimization | Tasks for optimizing data files (re-indexing, calculation of statistics). | | hlpTask | Scheduled tasks that run a stored procedure. |
Remarks Necessary rights To list the tasks for refreshing materialized views or scheduled tasks, it is necessary to have the connection rights (constant hRightsConnection or hRightsEncryptedConnection) for each database that contains a view to process or a stored procedure to run.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|