操作問い合わせ #1841
closedBUG consult sql job execution result
Status:
終了
Priority:
通常
Assignee:
-
Start date:
05/09/2015
Description
default Jarb Manager SQL result not found
1431100724:select JR.*, DM.message as message from ja_run_log_table AS JR, ja_define_run_log_message_table as DM where JR.log_date >= '20150501000000000' and JR.log_date <= '20150508235959999' and JR.message_id=DM.message_id and DM.lang='pt_br' order by JR.inner_jobnet_main_id,JR.log_date;¶
SQL FOUND
select JR.*, DM.message as message from ja_run_log_table AS JR, ja_define_run_log_message_table as DM where JR.log_date >= '20150501000000000' and JR.log_date <= '20150508235959999' and JR.message_id=DM.message_id and DM.lang='en' order by JR.inner_jobnet_main_id,JR.log_date;
how do I restirar the variable DM.lang='pt_br' of the jorb manager sql query result
Files
Updated by Anonymous over 9 years ago
How can I remove this variable from my query?
Updated by Anonymous over 9 years ago
I find out where was the problem! My User in zabbix was set to Brazil the Portuguese to switch to English it worked normally!