|
|
|
mysql> SELECT * FROM ja_run_jobnet_table where inner_jobnet_id = '15000000000000 00013';
|
|
Empty set (0.00 sec)
|
|
|
|
mysql> SELECT * FROM ja_run_jobnet_summary_table where inner_jobnet_id = '150000 0000000000013';
|
|
+---------------------+----------------+---------------------+-----------+----------+--------+------------+-------------------+-------------+----------------+----------------+----------------+-------------+-------------------+-----------+-----------+-------------+------+-------------+-------------+-----------+---------------------+----------------+------------------+--------------+--------------------+------------------+--------------------+------------------------+----------------+------------------+---------------------+
|
|
| inner_jobnet_id | update_date | created_date | invo_flag | run_type | status | job_status | jobnet_abort_flag | load_status | scheduled_time | start_time | end_time | public_flag | multiple_start_up | jobnet_id | user_name | jobnet_name | memo | schedule_id | calendar_id | boot_time | execution_user_name | running_job_id | running_job_name | virtual_time | virtual_start_time | virtual_end_time | start_pending_flag | initial_scheduled_time | jobnet_timeout | timeout_run_type | jobnet_timeout_flag |
|
|
+---------------------+----------------+---------------------+-----------+----------+--------+------------+-------------------+-------------+----------------+----------------+----------------+-------------+-------------------+-----------+-----------+-------------+------+-------------+-------------+-----------+---------------------+----------------+------------------+--------------+--------------------+------------------+--------------------+------------------------+----------------+------------------+---------------------+
|
|
| 1500000000000000013 | 20200819172721 | 2020-08-19 18:08:47 | 1 | 3 | 3 | 0 | 0 | 0 | 0 | 20200819172814 | 20200819180847 | 1 | 0 | JOBNET_2 | 9000320 | test | | NULL | NULL | NULL | 9000320 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|
|
+---------------------+----------------+---------------------+-----------+----------+--------+------------+-------------------+-------------+----------------+----------------+----------------+-------------+-------------------+-----------+-----------+-------------+------+-------------+-------------+-----------+---------------------+----------------+------------------+--------------+--------------------+------------------+--------------------+------------------------+----------------+------------------+---------------------+
|
|
1 row in set (0.00 sec)
|
|
|
|
mysql>
|
|
mysql> SELECT * FROM zabbix.ja_run_job_table where inner_jobnet_id = '1500000000 000000013';
|
|
+--------------+---------------------+----------------------+----------------------+---------------------+-----------+----------+-----------+-------------+------------+--------------+--------+------------+-----------+----------------+----------------+---------+---------+--------+----------+---------------+----------+-------------------+
|
|
| 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 |
|
|
+--------------+---------------------+----------------------+----------------------+---------------------+-----------+----------+-----------+-------------+------------+--------------+--------+------------+-----------+----------------+----------------+---------+---------+--------+----------+---------------+----------+-------------------+
|
|
| 53 | 1500000000000000013 | 1500000000000000013 | 0 | 2020-08-19 18:08:46 | 0 | 1 | 1 | 0 | 0 | 0 | 3 | 1 | 1 | 20200819180846 | 20200819180846 | 550 | 186 | END-1 | | 0 | | |
|
|
| 54 | 1500000000000000013 | 1500000000000000013 | 55 | 2020-08-19 18:08:46 | 0 | 4 | 1 | 2 | 1 | 0 | 3 | 1 | 1 | 20200819172815 | 20200819180846 | 383 | 188 | JOB-1 | | 0 | | |
|
|
| 56 | 1500000000000000013 | 1500000000000000013 | 0 | 2020-08-19 17:28:15 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 0 | 0 | 20200819172815 | 20200819172815 | 171 | 198 | START | | 0 | | |
|
|
+--------------+---------------------+----------------------+----------------------+---------------------+-----------+----------+-----------+-------------+------------+--------------+--------+------------+-----------+----------------+----------------+---------+---------+--------+----------+---------------+----------+-------------------+
|
|
3 rows in set (0.00 sec)
|
|
|
|
mysql>
|
|
mysql>
|