ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Lists the scheduled tasks of an HFSQL Client/Server server for a given connection.
Syntax
<Result> = HListTask(<Connection>)
<Result>: Character string
List of scheduled tasks found on the server in the following format:
<Identifier of task 1> + TAB + <Description of task 1> + TAB + ...
<Task 1 enabled or not> + TAB + <User> + TAB + <Month> + TAB + ...
<Day of month> + TAB + <Day of week> + TAB + <Hour> + TAB + ...
<Minute> + TAB + <Day of month or day of week> + TAB + ...
<Number of executions> + TAB + <Procedure name> + EOT +...

Remark: To get the characteristics of a task, use HInfoTask.
<Connection>: Character string or Connection variable
Connection for which the scheduled tasks must be listed. This connection corresponds to:
Remarks
  • To list the tasks of other users, you must have the rights to see the users (hRightSeeUser constant in HInfoServerRights and HModifyServerRights).
  • To list the scheduled tasks, you must have the rights to connect (hRightsConnection or hRightsEncryptedConnection constant) to the database containing the stored procedure.
  • You have the ability to use HListTask to check the existence of a task. All you have to do is check whether the task identifier is found among the tasks returned by the function.
Component: wd290hf.dll
Minimum version required
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help