• the call to a stored procedure,
• a backup.

Creating a scheduled task

1. Connect to the requested HFSQL server.
2. Select "Scheduled tasks".
3. Click the "Create" button. The wizard for creating a scheduled task starts.
4. Specify the scheduling options:
   • months of execution: every month, some months
   • day of execution: every day, certain days of the week or month
   • running time: at a fixed time or regularly throughout the day
5. Indicate the content of scheduled task:
   • Stored procedure: enter the name of the database, the name of the collection containing the stored procedure and select the procedure..
     Warning: for a stored procedure launched from a scheduled task to access data, you must use the HDeclareExternal function.. 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 started from the remote HFSQL administrator, there is no current analysis and the 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.
   • Backup:
     • Specify the items to be backed up: server contents, a specific database or a selection of databases.
     • Specify whether the backup must contain the index files (index files with a NDX extension and full-text index files with a FTX extension). If the index files are not saved, the size of the backup will be reduced but the restore time will be longer. Note: if the index files are not backed up, it will be necessary to provide the file passwords at restore time to enable them to be re-indexed.
     • Specify the backup directory. If this name corresponds to a relative path, the backup will be performed in the "Backup" subdirectory of the HFSQL server. The wizard is used to define a "backup" subdirectory ("Backup" by default). The date and the time (in "Year\Month\Day\Time-Minute" format) can be added to the name of the directory in order to easily identify the backup.
       Note: Backups are made in a numbered subdirectory (e.g. "backup\Backup\1").. Therefore, if several backups are performed, the corresponding files will not be overwritten by a new backup.
6. Give a description to your scheduled task and validate.
7. The scheduled task is automatically displayed in the remote HFSQL administrator.

Deleting a scheduled task

1. Connect to the requested HFSQL server.
2. Select "Scheduled tasks".
3. Select the scheduled task to delete.
4. Click "Delete".