sys_job_log.md
1.19 KB
sys_job_log
定时任务调度日志表
- Rows (estimated): 0
- Data size: 16.0 KB
- Engine: InnoDB
- Collation: utf8mb3_general_ci
- Created: 2026-04-27 18:57:06
- Updated:
Columns
| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | job_log_id |
bigint |
NO | PRI | auto_increment | 任务日志ID | |
| 2 | job_name |
varchar(64) |
NO | 任务名称 | |||
| 3 | job_group |
varchar(64) |
NO | 任务组名 | |||
| 4 | invoke_target |
varchar(500) |
NO | 调用目标字符串 | |||
| 5 | job_message |
varchar(500) |
YES | 日志信息 | |||
| 6 | status |
char(1) |
YES | 0 | 执行状态(0正常 1失败) | ||
| 7 | exception_info |
varchar(2000) |
YES | 异常信息 | |||
| 8 | create_time |
datetime |
YES | 创建时间 | |||
| 9 | job_id |
bigint |
YES | 任务ID |
Indexes
| Name | Unique | Type | Columns |
|---|---|---|---|
PRIMARY |
✓ | BTREE | job_log_id |
Narrative
No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.