This topic describes how to view the basic information
pertaining to current status of the asynchronous task and
the last log entry, associated with the given task ID
(UUID
) or task alias.
Ensure that you have the required roles.
To view the basic information related to current status of
the asynchronous task associated with the given task ID
(UUID
) or task alias use the
task_status_brief
function.
mysql> SELECT mysql_tasks.task_status_brief('task_id');
Replace the task_id
with the unique
task ID (UUID
) of the task whose
current status is required.
mysql> SELECT mysql_tasks.task_status_brief('c169384c-3b7e-11f0-a5dc-02001712c792')\G
*************************** 1. row ***************************
mysql_tasks.task_status_brief('c169384c-3b7e-11f0-a5dc-02001712c792'):
{"data": null, "status": "COMPLETED", "message": "Execution finished.", "progress": 100}
For example:
This example returns basic information related to the
current status of the asynchronous task with task ID
c169384c-3b7e-11f0-a5dc-02001712c792
.