2.6.4.2 Viewing Task Status

The topic describes how to retrieve the complete information related to the current status of the asynchronous task associated with the given task ID (UUID)s or task alias.

Before You Begin

Ensure that you have the required roles.

Viewing Task Status Using Task ID

To retrieve the complete information related to the current status of the asynchronous task based on the given task ID use the task_status function.

Press CTRL+C to copy
 
mysql> SELECT mysql_tasks.task_status('task_id');

Replace the task_id with the unique task ID (UUID) of the task whose current status is required.

For example:

Press CTRL+C to copy
 
mysql>  SELECT mysql_tasks.task_status('c169384c-3b7e-11f0-a5dc-02001712c792')\G
*************************** 1. row ***************************
mysql_tasks.task_status('c169384c-3b7e-11f0-a5dc-02001712c792'): 
{"id": "c169384c-3b7e-11f0-a5dc-02001712c792", "data": null, "name": "Create table for flight from US",
"alias": "Wed-8", "status": "COMPLETED", "message": "Execution finished.", "progress": 100, 
"row_hash": "d74917aed8434dd9ece5c66d7b2b7349", "task_data": {"country": "US", 
"mysqlMetadata": {"autoGc": true, "events": ["`airportdb`.`c1692beb-3b7e-11f0-a5dc-02001712c792`"]}}, 
"task_type": "Async_SQL", "server_uuid": "52cd41ee-16ac-11f0-8bc9-020017253b2b", "progress_bar": "##########", 
"connection_id": 5755, "starting_time": "2025-05-28 04:46:45.000000", "scheduled_time": "2025-05-28 04:46:45.000000", 
"estimated_remaining_time": 0.00000, "estimated_completion_time": "2025-05-28 04:46:45.000000"}

This example returns the current status of the asynchronous task with task ID c169384c-3b7e-11f0-a5dc-02001712c792.