ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

New WINDEV, WEBDEV and WINDEV Mobile 2025 feature!
Help / WLanguage / Managing databases / HFSQL / Types of HFSQL variables
  • WLanguage properties that can be used with the hSchedulingHistory type
  • Functions that use hSchedulingHistory variables
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
hSchedulingHistory (Variable type)
In french: hHistoriquePlanification
HFSQL Client/ServerAvailable 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.
Example
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 nameType usedEffect
StartDateDateTimeStart date and time of the scheduled job.
This property is read-only.
EndDateDateTimeEnd date and time of the scheduled job.
This property is read-only.
ErrorCharacter stringError encountered (if the Status property is set to the hExecSchedulingError constant).
IdentifierIntegerIdentifier of the scheduled job execution.
This property is read-only.
ManualRunBoolean
  • 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.
StatusIntegerStatus 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.
TypeIntegerScheduled 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.
UserCharacter 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:
New in version 2025
HDeleteSchedulingHistory
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.
New in version 2025
HListSchedulingHistory
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.
Minimum version required
  • Version 2025
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/24/2025

Send a report | Local help