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.