HeatWave Release Notes
The app_task_status_brief routine returns
the brief status of an application task, including a subset
of information about the task and its last log entry.
This topic contains the following sections:
mysql> SELECT mysql_tasks.app_task_status_brief(
IN 'app_user_id' VARCHAR(255),
IN 'task_id' VARCHAR(36));
Following are app_task_status_brief
parameters:
app_user_id(VARCHAR(255)): specifies the unique ID of the application user who owns the task.task_id(VARCHAR(36)): specifies the unique task ID (UUID) of the task for which the current task status is required.
mysql> SELECT JSON_PRETTY(mysql_tasks.app_task_status_brief('app_user_01', @task_id));The output is similar to the following:
+--------------------------------------------------------------------------------------------------------------------------------------+
| JSON_PRETTY(mysql_tasks.app_task_status_brief('app_user_01', @task_id)) |
+--------------------------------------------------------------------------------------------------------------------------------------+
| {
"data": {
"Task result": "Finished..."
},
"status": "COMPLETED",
"message": "Execution finished.",
"progress": 100
} |
+--------------------------------------------------------------------------------------------------------------------------------------+
This example returns basic information related to the
current status of the asynchronous task associated with
the specified application-managed user ID and task ID
stored in the session variable
@task_id.