|
|
|
|
|
- WLanguage properties that can be used with the hSchedulingHistory type
- Functions that use hSchedulingHistory variables
hSchedulingHistory (Variable type) In french: hHistoriquePlanification
Available only with this kind of connection
The hSchedulingHistory type is used to get all the characteristics of the execution history of a scheduled job (optimization, backup, etc.). These characteristics can be identified using different WLanguage properties. Note: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable. mySchedule is hSchedulingHistory
Properties WLanguage properties that can be used with the hSchedulingHistory type The following properties can be used to define the characteristics of hSchedulingHistory variables: | | | Property name | Type used | Effect |
---|
StartDate | DateTime | Start date and time of the scheduled job. This property is read-only. | EndDate | DateTime | End date and time of the scheduled job. This property is read-only. | Error | Character string | Error encountered (if the Status property is set to the hExecSchedulingError constant). | Identifier | Integer | Identifier of the scheduled job execution. This property is read-only. | ManualRun | Boolean | - True if the scheduled job was started manually (i.e. via a WLanguage function or via the HFSQL Control Center),
- False otherwise.
This property is read-only. | Status | Integer | Status of the scheduled job execution: - hExecSchedulingCanceled: The execution of the scheduled job has been canceled.
- hExecSchedulingInProgress: The scheduled job is being executed.
- hExecSchedulingError: The execution of the scheduled job encountered an error.
- hExecSchedulingCompleted: The execution of the scheduled job has been completed.
This property is read-only. | Type | Integer | Scheduled job executed: - hlpOptimization: Data file optimization.
- hlpFullBackup: Full backup.
- hlpDifferentialBackup: Differential backup.
- hlpTask: Scheduled task.
- hlpMaterializedView: Refresh a materialized view.
This property is read-only. | User | Character string | - User who created the scheduled job, if it was executed automatically.
- User who executed the scheduled job, if it was executed manually.
This property is read-only. |
Remarks Functions that use hSchedulingHistory variables The following functions use hSchedulingHistory variables:
| | | Deletes 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. | | 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. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|