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

Press CTRL+C to copy
 
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.