Create a planned optimization

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 "Planned items" group, pull down "New planning" and select "Plan optimization". The wizard for creating a planned optimization is launched.
4. Select the files to optimize:
   • A database,
   • A selection of database files.
5. Define task frequency: month, day, hour.
6. Indicate the action taken:
   • Reindex indexes:
     This action provides optimum access to the indexes. The reindex operation automatically recalculates the statistics on the keys.
   • Recalculate file key statistics:
     This action optimizes data file paths.
7. Specify data file passwords if necessary.
   Caution: If different passwords are used on data files, it is necessary to create a different optimization task for each data file associated with a different password.
8. Give your scheduled task a description and validate the wizard.
9. Scheduled optimization appears in the "Scheduled items" tab of the HFSQL Control Center.

Delete a scheduled optimization

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 optimization to be deleted.
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 planned optimization

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 planned optimization to be modified.
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 if the optimization is active.
   • Tab "Scheduling": Defines the scheduled optimization execution options (month, day, time).
   • Tab "Content": Defines the elements included in the planned optimization (server, database, files, etc.) as well as the action performed.
   • Novedad versión 2025
     Tab "Execution History": This tab appears when the scheduled optimization has been executed automatically. This tab lists the different automation executions of the scheduled task, indicating:

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