ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

New WINDEV, WEBDEV and WINDEV Mobile 2025 feature!
This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / Types of HFSQL variables
  • WLanguage properties for use with type hHistoryPlanning
  • Functions manipulating variables of type hHistoryPlanning
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
hHistoryPlanning (Variable type)
In french: hSchedulingHistory
HFSQL Client/ServerAvailable only with this kind of connection
The type hHistoryPlanning allows you to view all the characteristics of a task's execution history. These characteristics can be identified using various 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
myHistory is TO hHistoryPlanning
Properties

WLanguage properties for use with type hHistoryPlanning

The following properties can be used to manipulate a variable of type hHistoryPlanning:
Property nameType usedEffect
StartDateDateTimeStart date and time of planning execution.
This property is read-only.
EndDateDateTimeEnd date and time of planning execution.
This property is read-only.
ErrorCharacter stringError encountered (if property Status property corresponds to the constant hExecPlanningError).
IdentifierentierJob identifier.
This property is read-only.
LaunchManualBoolean
  • True if execution of the scheduled task has been started manually (i.e. via a WLanguage function or via the HFSQL Control Center),
  • False otherwise.
This property is read-only.
StatusentierStatus of task scheduler execution:
  • hExecPlanningCancelled The execution of the scheduled task has been cancelled.
  • hExecPlanningInProgress The scheduled task is currently running.
  • hExecPlanningError Scheduled task execution is in error.
  • hExecPlanningTerminated The execution of the scheduled task has been completed.
This property is read-only.
TypeentierType of scheduled task executed:
  • hlpOptimization Data file optimization.
  • hlpCompleteBackup Complete backup.
  • hlpDifferentialBackup: Differential Backups.
  • hlpTask Planned task.
  • hlpMaterializedView Refresh a materialized view.
This property is read-only.
UserCharacter string
  • If run automatically, user who created task.
  • If executed manually, user who performed the task.
This property is read-only.
Remarks

Functions manipulating variables of type hHistoryPlanning

The following functions can be used to manipulate variables of type hHistoryPlanning:
New in version 2025
HListHistoryPlanning
Lists the execution history of a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view).
New in version 2025
HSuppressHistoryPlanning
Deletes the execution history of a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.).
Minimum version required
  • Version 2025
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 10/18/2024

Send a report | Local help