10.1.4.3 add_task_log

MySQL HeatWave User Guide

10.1.4.3 add_task_log

The add_task_log routine add a log entry for the task with the specified ID. You can use this routine with an application-level task as well and it does not require an application-managed user ID.

Syntax

mysql> CALL mysql_tasks.add_task_log(
  IN 'task_id' VARCHAR(36),
  IN 'message' VARCHAR(2000), 
  IN 'data' JSON, 
  IN progress SMALLINT, 
  IN 'status' ENUM
  );

Following are add_task_log parameters:

task_id VARCHAR(36): specifies the unique task ID (UUID) of the task for which you want to add logs.
message VARCHAR(2000): specifies the log message to add.
data JSON: specifies additional log data. If there is no additional data, set to NULL.
progress SMALLINT: specifies the task progress percentage from 0 to 100.
status ENUM: specifies the current task status. Possible values are: SCHEDULED, RUNNING, COMPLETED, ERROR, or CANCELLED.

Syntax Example

See the execute_prepared_stmt_from_app_async routine example.

See Also

Running tasks Asynchronously.