2.6.4.1 Viewing Task Details

This topic describes how to view detailed information about a single task based on the specified task ID (UUID) or task alias.

Before You Begin

Ensure that you have the required roles.

Viewing Task Details

To view the task details, use the task function.

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

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

For example:

Press CTRL+C to copy
 
mysql> SELECT mysql_tasks.task('c169384c-3b7e-11f0-a5dc-02001712c792')\G
*************************** 1. row ***************************
mysql_tasks.task('c169384c-3b7e-11f0-a5dc-02001712c792'): {"id": "c169384c-3b7e-11f0-a5dc-02001712c792", 
"data": {"country": "US", "mysqlMetadata": {"autoGc": true, "events": ["`airportdb`.`c1692beb-3b7e-11f0-a5dc-02001712c792`"]}}, 
"name": "Create table for flight from US", "alias": "Wed-8", "task_type": "Async_SQL", "connection_id": 5755, "data_json_schema": 
{"type": "object", "required": ["mysqlMetadata"], "properties": {"mysqlMetadata": {"type": "object", "required": ["events", "autoGc"], 
"properties": {"autoGc": {"type": "boolean"}, "events": {"type": "array", "items": {"type": "string"}, 
"minItems": 1, "uniqueItems": true}}}}}, "log_data_json_schema": null}

This example retrieves all the task information associated with the task alias (c169384c-3b7e-11f0-a5dc-02001712c792).