• 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.

• in the HFSQL Control Center. The scheduled elements can be managed at server level.
• through programming.

Creating 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:
   • Backup.
   • Task.
   • Optimization.
   • Refreshing a materialized view.
6. Regardless of the option, a wizard allows you to create the selected scheduling.

Deleting 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

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.