Skip to main content
Skip to main content

JOBS

jobs​

Name​

tip

jobs

  • since 2.1

description​

Table function, generating a temporary task table, which can view job information in a certain task type.

This function is used in the from clause.

syntax​

jobs("type"="")

parameter description

parameterdescriptiontyperequired
typejob typestringyes

the type supported types

  • insert: insert into type job
  • mv: materialized view job
insert job​

jobs("type"="insert")Table structure:

mysql> desc  function jobs("type"="insert");
+-------------------+------+------+-------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+------+------+-------+---------+-------+
| Id | TEXT | No | false | NULL | NONE |
| Name | TEXT | No | false | NULL | NONE |
| Definer | TEXT | No | false | NULL | NONE |
| ExecuteType | TEXT | No | false | NULL | NONE |
| RecurringStrategy | TEXT | No | false | NULL | NONE |
| Status | TEXT | No | false | NULL | NONE |
| ExecuteSql | TEXT | No | false | NULL | NONE |
| CreateTime | TEXT | No | false | NULL | NONE |
| SucceedTaskCount | TEXT | No | false | NULL | NONE |
| FailedTaskCount | TEXT | No | false | NULL | NONE |
| CanceledTaskCount | TEXT | No | false | NULL | NONE |
| Comment | TEXT | No | false | NULL | NONE |
+-------------------+------+------+-------+---------+-------+
12 rows in set (0.01 sec)
  • Id: job ID.
  • Name: job name.
  • Definer: job definer.
  • ExecuteType: Execution type
  • RecurringStrategy: recurring strategy
  • Status: Job status
  • ExecuteSql: Execution SQL
  • CreateTime: Job creation time
  • SucceedTaskCount: Number of successful tasks
  • FailedTaskCount: Number of failed tasks
  • CanceledTaskCount: Number of canceled tasks
  • Comment: job comment

SuccessTaskCount, FailedTaskCount, and CanceledTaskCount are invalid for 2.1.4 and earlier versions.

matterialized view job​

jobs("type"="mv")Table structure:

mysql> desc function jobs("type"="mv");
+-------------------+------+------+-------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+------+------+-------+---------+-------+
| Id | TEXT | No | false | NULL | NONE |
| Name | TEXT | No | false | NULL | NONE |
| MvId | TEXT | No | false | NULL | NONE |
| MvName | TEXT | No | false | NULL | NONE |
| MvDatabaseId | TEXT | No | false | NULL | NONE |
| MvDatabaseName | TEXT | No | false | NULL | NONE |
| ExecuteType | TEXT | No | false | NULL | NONE |
| RecurringStrategy | TEXT | No | false | NULL | NONE |
| Status | TEXT | No | false | NULL | NONE |
| CreateTime | TEXT | No | false | NULL | NONE |
+-------------------+------+------+-------+---------+-------+
10 rows in set (0.00 sec)
  • Id: job ID.
  • Name: job name.
  • MvId: Materialized View ID
  • MvName: Materialized View Name
  • MvDatabaseId: DB ID of the materialized view
  • MvDatabaseName: Name of the database to which the materialized view belongs
  • ExecuteType: Execution type
  • RecurringStrategy: Loop strategy
  • Status: Job status
  • CreateTime: Task creation time

example​

  1. View jobs in all materialized views
mysql> select * from jobs("type"="mv");
  1. View job with name inner_mtmv_75043
mysql> select * from jobs("type"="mv") where Name="inner_mtmv_75043";
  1. View all insert jobs
mysql> select * from jobs("type"="insert");
  1. View job with name one_insert_job
mysql> select * from jobs("type"="insert") where Name='one_insert_job';

keywords​

jobs, job, insert, mv, materialized view, schedule