|
MariaDB [zabbix]> SELECT * FROM ja_run_job_table WHERE inner_jobnet_main_id = 20574;
|
|
+--------------+-----------------+----------------------+----------------------+---------------------+-----------+----------+-----------+-------------+------------+--------------+--------+------------+-----------+----------------+----------------+---------+---------+-----------------+--------------------------------------------------------------+---------------+----------+-------------------+
|
|
| inner_job_id | inner_jobnet_id | inner_jobnet_main_id | inner_job_id_fs_link | created_date | invo_flag | job_type | test_flag | method_flag | force_flag | timeout_flag | status | boot_count | end_count | start_time | end_time | point_x | point_y | job_id | job_name | continue_flag | run_user | run_user_password |
|
|
+--------------+-----------------+----------------------+----------------------+---------------------+-----------+----------+-----------+-------------+------------+--------------+--------+------------+-----------+----------------+----------------+---------+---------+-----------------+--------------------------------------------------------------+---------------+----------+-------------------+
|
|
| 245421 | 20574 | 20574 | 0 | 2025-03-23 00:05:07 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 29 | 444 | END-1 | | 0 | | |
|
|
| 245422 | 20574 | 20574 | 245423 | 2025-03-23 01:06:54 | 0 | 4 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 20250323010501 | 20250323010654 | 29 | 150 | IPDJOB0000095-1 | 本番_TES-WEBサーバ_サービス停止 | 0 | | |
|
|
| 245424 | 20574 | 20574 | 245425 | 2025-03-24 08:20:11 | 0 | 4 | 0 | 3 | 0 | 0 | 6 | 1 | 1 | 20250323010655 | 0 | 29 | 212 | IPDJOB0000095-2 | 本番_TES-DBサーバ_サービス停止_バックアップ | 0 | | |
|
|
| 245426 | 20574 | 20574 | 245427 | 2025-03-24 08:19:49 | 0 | 4 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 29 | 275 | IPDJOB0000095-3 | 本番_TES-WEB/DBサーバ_サービス起動 | 0 | | |
|
|
| 245428 | 20574 | 20574 | 245429 | 2025-03-23 01:06:29 | 0 | 4 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 20250323010501 | 20250323010629 | 122 | 150 | IPDJOB0000095-4 | 本番_TES-WEBサーバ_サービス停止 | 0 | | |
|
|
| 245430 | 20574 | 20574 | 245431 | 2025-03-23 01:07:45 | 0 | 4 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 20250323010630 | 20250323010745 | 122 | 212 | IPDJOB0000095-5 | 本番_TES-DBサーバ_サービス停止_バックアップ | 0 | | |
|
|
| 245432 | 20574 | 20574 | 245433 | 2025-03-23 01:09:13 | 0 | 4 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 20250323010746 | 20250323010913 | 122 | 275 | IPDJOB0000095-6 | 本番_TES-DBサーバ_サービス起動 | 0 | | |
|
|
| 245434 | 20574 | 20574 | 245435 | 2025-03-23 01:13:05 | 0 | 4 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 20250323010914 | 20250323011305 | 122 | 336 | IPDJOB0000095-7 | 本番_TES-WEB/DBサーバ_サービス起動 | 0 | | |
|
|
| 245436 | 20574 | 20574 | 0 | 2025-03-23 01:13:05 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 54 | 381 | MTE-1 | | 0 | | |
|
|
| 245437 | 20574 | 20574 | 0 | 2025-03-23 01:05:01 | 0 | 6 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 20250323010501 | 20250323010501 | 54 | 90 | MTS-1 | | 0 | | |
|
|
| 245438 | 20574 | 20574 | 0 | 2025-03-23 01:05:01 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 20250323010501 | 20250323010501 | 29 | 28 | START | | 0 | | |
|
|
+--------------+-----------------+----------------------+----------------------+---------------------+-----------+----------+-----------+-------------+------------+--------------+--------+------------+-----------+----------------+----------------+---------+---------+-----------------+--------------------------------------------------------------+---------------+----------+-------------------+
|
|
11 rows in set (0.001 sec)
|
|
|
|
MariaDB [zabbix]>
|
