• in the HFSQL Control Center.
• by programming.

Creating a scheduled task

1. If necessary, connect to an HFSQL server and display the description of the server or one of its databases (double-click on the server or database name in the tree structure).
2. Click the "Scheduled elements" tab.
3. In the ribbon, in the "Scheduled elements" group, expand "New scheduling" and select "Schedule a task". The wizard for creating a scheduled task starts.
4. Select the task execution mode: the task can be executed:
   • Periodically. Then wizard allows you to define the runtime frequency of the task.
   • and/or whenever starting the HFSQL server. If this option is selected, you must specify whether:
     • the task is blocking: in this case, the HFSQL server will be inaccessible while the task is running..
     • the task must be run in the background: in this case, the HFSQL server can be used as soon as it starts up..
5. Select:
   • the database containing the stored procedure to run.
   • the set containing the stored procedure to run.
   • the stored procedure to run.
     Caution: For a stored procedure launched from a scheduled task to access data, the HDeclareExternal function must be used.. This function is used to declare the data sources that will be used in the processes of the stored procedure. Indeed, when a stored procedure is launched from the HFSQL Control Center, there is no analysis in progress and HFSQL Client/Server data is not immediately accessible.
     If HDeclareExternal is not used in the code of the stored procedure, the procedure will trigger a fatal error, notified in the log of system events.
     Note: when a stored procedure is launched from a WINDEV, WEBDEV or WINDEV Mobile application using the HExecuteProcedure function, it uses the application's analysis and can therefore directly use HFSQL Client/Server data.
6. Define task frequency: month, day, hour.
7. Give your scheduled task a description and validate the wizard.
8. The scheduled task appears in the "Scheduled items" tab of the HFSQL Control Center.

Deleting a scheduled task

1. If necessary, connect to an HFSQL server and display the appropriate server or database tab.
2. Click the "Scheduled elements" tab.
3. Select the scheduled task to delete.
4. In the ribbon, in the "Scheduled elements" group, click "Delete".
   You also have the ability to use the context menu of the scheduled element ("Delete" option).

Modifying a scheduled task

1. If necessary, connect to an HFSQL server and display the appropriate server or database tab.
2. Click the "Scheduled elements" tab.
3. Select the scheduled task to modify.
4. In the ribbon, in the "Scheduled elements" group, click "Edit".
   You also have the ability to use the context menu of the scheduled element ("Edit" option).
5. A description window of the scheduled element is displayed. All the characteristics typed in the wizard are grouped in several tabs:
   • Tab "General": Defines whether the task is active and its type (backup or stored procedure).
   • Tab "Scheduling": Sets the execution options for the scheduled task (month, day, time, number of executions, execution at startup).
   • New in version 2025
     Tab "Execution History": This tab appears when the scheduled task has been executed automatically. This tab lists the different automation executions of the scheduled task, indicating:

     • the start date of the task,
     • task status: completed, in progress, error,
     • running time,
     • the user who launched the task,
     • if launched manually (via HExecuteScheduling).
6. Validate.

Creating a scheduled task

1. Create a variable of type hScheduledTask and describe the various characteristics of the scheduled task.
2. Add the scheduled task using the HAddScheduling function (or the HAddTask function).

• To add a scheduled task, you must have:
  • the rights to manage the tasks (hRightsManageTask constant).
  • the rights to run the command linked to the scheduled task.
• The task will be performed with the identity of the user defined by the connection.
• For compatibility, it is also possible to create a scheduled task for backing up the. However, it is advisable to create a scheduled backup. For more details, see How to backup HFSQL Client/Server databases?.

Handling scheduled tasks in WLanguage

• scheduled task management functions:
  

  HAddTask	Adds a scheduled task on the server defined by the connection.
  HDeleteTask	Deletes a scheduled task from an HFSQL Client/Server server.
  HInfoTask	Returns the characteristics of a scheduled task in a hScheduledTask variable].
  HListTask	Lists the scheduled tasks of an HFSQL Client/Server server for a given connection.
  HManageTask	Enables or disables a scheduled task on an HFSQL Client/Server server.
  HModifyTask	Modifies a scheduled task on the HFSQL server defined by the connection.
• planned item management functions (recommended):
  

  HAddScheduling	Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view.
  HDeleteScheduling	Delete a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.
  HExecuteScheduling	Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.
  HListScheduling	Lists scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view.
  HModifyScheduling	Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.