HeatWave Release Notes
The task_status
routine returns the task
status.
The application-level variant for this routine is
app_task_status
.
This topic contains the following sections:
Press CTRL+C to copymysql> SELECT mysql_tasks.task_status(IN 'task_id' VARCHAR(36));
The task_id
(VARCHAR 36) parameter
specifies the unique task ID (UUID
) of
the task whose information is required.
Press CTRL+C to copymysql> SELECT JSON_PRETTY(mysql_tasks.task_status(@task_id));
This example returns the status of the asynchronous task
with task ID stored in the session variable
@task_id
. The output is similar to the
following:
Press CTRL+C to copy| { "id": "17efb56b-52a1-11f0-bca4-020017205654", "data": { "Async Task completed at": "2025-06-26 15:20:34.000000" }, "name": "DemoAsyncTask", "alias": "Thu-7", "status": "COMPLETED", "message": "Execution finished.", "progress": 100, "row_hash": "fa701b650afd8638049f8fd436a500f5", "task_data": { "mysqlMetadata": { "autoGc": true, "events": [ "`demo_db`.`17ef9cf8-52a1-11f0-bca4-020017205654`" ] } }, "task_type": "Async_SQL", "server_uuid": "5172a252-8a06-11ef-b3bb-02001727ecef", "progress_bar": "##########", "connection_id": 65220, "starting_time": "2025-06-26 15:20:29.000000", "scheduled_time": "2025-06-26 15:20:29.000000", "estimated_remaining_time": 0.00000, "estimated_completion_time": "2025-06-26 15:20:34.000000" } |