JOBS
jobs
Name
jobs
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.
This function is supported since 2.1.0.
syntax
jobs("type"="")
parameter description
parameter | description | type | required |
---|---|---|---|
type | job type | string | yes |
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
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
- View jobs in all materialized views
mysql> select * from jobs("type"="mv");
- View job with name
inner_mtmv_75043
mysql> select * from jobs("type"="mv") where Name="inner_mtmv_75043";
- View all insert jobs
mysql> select * from jobs("type"="insert");
- 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