10.1.4.17 kill_app_task

The kill_app_task routine kills an active or scheduled task using its task ID. Users can only terminate tasks they own.

Syntax

mysql> SELECT mysql_tasks.kill_app_task(
  IN 'app_user_id' VARCHAR(255), 
  IN 'task_id' VARCHAR(36);

Following are kill_app_task 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 to be terminated.

Syntax Example

mysql> SELECT mysql_tasks.kill_app_task('app_user_01','698968b7-3b96-11f0-a5dc-02001712c792');

This example terminates the task created by the specified application user and with the specified task ID.

See Also

Running tasks Asynchronously.