Documentation Home
HeatWave User Guide
Related Documentation Download this Manual
PDF (US Ltr) - 2.5Mb
PDF (A4) - 2.5Mb


2.20.1.12 task_status_brief

The task_status_brief routine returns the brief status of a task, including a subset of information about the task and its last log entry.

The application-level variant for this routine is app_task_status_brief.

This topic contains the following sections:

Syntax
mysql> SELECT mysql_tasks.task_status_brief(IN 'task_id' VARCHAR(36));

The task_id (VARCHAR(36)) parameter specifies the unique task ID (UUID) of the task whose log entries are required.

Syntax Example
mysql> SELECT JSON_PRETTY(mysql_tasks.task_status_brief(@task_id));

The output is similar to the following:

  | {
  "data": {
    "Async Task completed at": "2025-06-26 14:17:38.000000"
  },
  "status": "COMPLETED",
  "message": "Execution finished.",
  "progress": 100
} |

This example returns basic information related to the current status of the asynchronous task with task ID stored in the session variable @task_id.