|
MariaDB [zabbix]> desc ja_run_job_table;
|
|
+----------------------+---------------------+------+-----+-------------------+-----------------------------+
|
|
| Field | Type | Null | Key | Default | Extra |
|
|
+----------------------+---------------------+------+-----+-------------------+-----------------------------+
|
|
| inner_job_id | bigint(20) unsigned | NO | PRI | 0 | |
|
|
| inner_jobnet_id | bigint(20) unsigned | NO | MUL | 0 | |
|
|
| inner_jobnet_main_id | bigint(20) unsigned | NO | MUL | 0 | |
|
|
| inner_job_id_fs_link | bigint(20) unsigned | NO | | 0 | |
|
|
| created_date | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
|
|
| invo_flag | int(11) | NO | | 0 | |
|
|
| job_type | int(11) | NO | | 0 | |
|
|
| test_flag | int(11) | NO | | 0 | |
|
|
| method_flag | int(11) | NO | | 0 | |
|
|
| force_flag | int(11) | NO | | 0 | |
|
|
| timeout_flag | int(11) | NO | | 0 | |
|
|
| status | int(11) | NO | MUL | 0 | |
|
|
| boot_count | int(11) | NO | | 0 | |
|
|
| end_count | int(11) | NO | | 0 | |
|
|
| start_time | bigint(20) unsigned | NO | | 0 | |
|
|
| end_time | bigint(20) unsigned | NO | | 0 | |
|
|
| point_x | int(11) | NO | | 0 | |
|
|
| point_y | int(11) | NO | | 0 | |
|
|
| job_id | varchar(32) | NO | | | |
|
|
| job_name | varchar(64) | YES | | NULL | |
|
|
| continue_flag | int(11) | NO | | 0 | |
|
|
| run_user | varchar(256) | YES | | NULL | |
|
|
| run_user_password | varchar(256) | YES | | NULL | |
|
|
+----------------------+---------------------+------+-----+-------------------+-----------------------------+
|
|
23 rows in set (0.00 sec)
|
|
|
|
MariaDB [zabbix]>
|
|
MariaDB [zabbix]>
|
|
MariaDB [zabbix]> SELECT * FROM ja_run_job_table where inner_job_id = 2900506;
|
|
Empty set (0.00 sec)
|
|
|
|
MariaDB [zabbix]>
|