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
<Connection variable>.ListTask (Function)
In french: <Variable Connexion>.ListeTâche
HFSQL Client/ServerAvailable only with this kind of connection
Lists the scheduled tasks of an HFSQL Client/Server server for a given connection.
Syntax
<Result> = <Connection>.ListTask()
<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 <Connection variable>.InfoTask.
<Connection>: Connection variable
Name of the Connection variable that describes the connection for which the scheduled tasks must be listed.
Remarks
  • To list the tasks of other users, you must have the rights to see the users (hRightSeeUser constant in <Connection variable>.InfoServerRights and <Connection variable>.ModifyServerRights).
  • 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 <Connection variable>.ListTask 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 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help