The task_status_brief
routine returns the
brief status of a task, including a subset of information
about the task and its last log entry.
The application-level variant for this routine is
app_task_status_brief
.
This topic contains the following sections:
mysql> SELECT mysql_tasks.task_status_brief(IN 'task_id' VARCHAR(36));
The task_id
(VARCHAR(36)) parameter
specifies the unique task ID (UUID
) of
the task whose log entries are required.
mysql> SELECT JSON_PRETTY(mysql_tasks.task_status_brief(@task_id));
The output is similar to the following:
| {
"data": {
"Async Task completed at": "2025-06-26 14:17:38.000000"
},
"status": "COMPLETED",
"message": "Execution finished.",
"progress": 100
} |
This example returns basic information related to the
current status of the asynchronous task with task ID
stored in the session variable
@task_id
.