2.6.5.5 Viewing Application Task Status Details

This topic describes how to view the basic information pertaining to current status of the application task and the last log entry, associated with the given task ID (UUID).

Before You Begin

Ensure that you have the required roles.

Viewing Asynchronous Task Status Details

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 app_task_status_brief function.

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

Replace the following:

• app_user_id: the unique ID of the application user who owns the task.

• task_id: the unique task ID (UUID) of the task for which the current task status is required.

For example:

Press CTRL+C to copy
 
mysql>  SELECT mysql_tasks.app_task_status_brief('app_user_01','2299b512-3b90-11f0-a5dc-02001712c792');
+------------------------------------------------------------------------------------------+
| mysql_tasks.app_task_status_brief('app_user_01','2299b512-3b90-11f0-a5dc-02001712c792')  |
+------------------------------------------------------------------------------------------+
| {"data": null, "status": "COMPLETED", "message": "Execution finished.", "progress": 100} |
+------------------------------------------------------------------------------------------+
1 row in set (0.2354 sec)

This example returns basic information related to the current status of the asynchronous task with task ID 2299b512-3b90-11f0-a5dc-02001712c792.