ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Control Centers / HFSQL Control Center / HFSQL Client/Server
  • Overview
  • Scheduled elements in the HFSQL Control Center
  • Creating a scheduled element
  • Deleting a scheduled element
  • Modifying a scheduled element
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
You have the ability to define scheduled elements on the HFSQL server. These scheduled elements can correspond to:
  • a backup (of the server, of one or more databases, of data files, etc.).
  • a scheduled task (call to a stored procedure). By calling a stored procedure, you can execute the code of your choice, e.g. custom maintenance, editing statistics, etc.
  • an optimization (of one or more databases, of one or more files, etc.).
  • a refresh of one or more materialized views.
The scheduled elements can be managed:
  • in the HFSQL Control Center. The scheduled elements can be managed at server level.
  • through programming.
Note: Scheduled item management is available at the server, database and file levels.. The "Scheduled elements" tab is available regardless of the displayed element (server, database or file).
Scheduled elements in the HFSQL Control Center

Creating a scheduled element

To create a scheduled element:
  1. Connect (if necessary) to an HFSQL server.
  2. Double-click the name of HFSQL server in the tree structure.
  3. The right section of Control Center displays a tab with the server name.
  4. Click the "Scheduled elements" tab.
  5. In the ribbon, in the "Scheduled elements" group, expand "New scheduling". You can choose the type of scheduling to create:
  6. Regardless of the option, a wizard allows you to create the selected scheduling.

Deleting a scheduled element

To delete a scheduled element:
  1. Connect (if necessary) to an HFSQL server.
  2. Double-click the name of HFSQL server in the tree structure.
  3. The right section of Control Center displays a tab with the server name.
  4. Click the "Scheduled elements" tab.
  5. Select the scheduled task to delete.
  6. 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 element

To modify a scheduled element:
  1. Connect (if necessary) to an HFSQL server.
  2. Double-click the name of HFSQL server in the tree structure.
  3. The right section of Control Center displays a tab with the server name.
  4. Click the "Scheduled elements" tab.
  5. Select the scheduled task to modify.
  6. 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).
  7. A description window of the scheduled element is displayed. All the characteristics entered in the wizard are grouped in several tabs.
  8. Modify the requested information and validate.
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 10/18/2024

Send a report | Local help