Differences

This shows you the differences between two versions of the page.

--- test3:batch [2026/01/02 07:33] – created admin
+++ test3:batch [2026/01/03 01:37] (current) – 125.141.42.106
@@ Line 1: / Line 1: @@
-* {{ :test3:배치원장.xlsx |}}
+  * {{ test3:배치원장.xlsx}}
+  * {{ test3:우편번호_배치.docx}}
+  * 배치증적
+<code>
+CALL CSVWRITE (
+'/tmp/out.csv',
+'select * from INFORMATION_SCHEMA.TABLES',
+'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
+);
+BATCH_JOB_EXECUTION_CONTEXT
+CALL CSVWRITE (
+'/tmp/BATCH_JOB_EXECUTION_CONTEXT.csv',
+'select * from BATCH_JOB_EXECUTION_CONTEXT',
+'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
+);
+BATCH_JOB_INSTANCE
+CALL CSVWRITE (
+'/tmp/BATCH_JOB_INSTANCE.csv',
+'select * from BATCH_JOB_INSTANCE',
+'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
+);
+BATCH_JOB_EXECUTION_PARAMS
+CALL CSVWRITE (
+'/tmp/BATCH_JOB_EXECUTION_PARAMS.csv',
+'select * from BATCH_JOB_EXECUTION_PARAMS',
+'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
+);
+BATCH_JOB_EXECUTION
+CALL CSVWRITE (
+'/tmp/BATCH_JOB_EXECUTION.csv',
+'select * from BATCH_JOB_EXECUTION',
+'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
+);
+BATCH_STEP_EXECUTION
+CALL CSVWRITE (
+'/tmp/BATCH_STEP_EXECUTION.csv',
+'select * from BATCH_STEP_EXECUTION',
+'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
+);
+BATCH_STEP_EXECUTION_CONTEXT
+CALL CSVWRITE (
+'/tmp/BATCH_STEP_EXECUTION_CONTEXT.csv',
+'select * from BATCH_STEP_EXECUTION_CONTEXT',
+'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
+);
+CALL CSVWRITE (
+'/tmp/batch-history-2025-10-23.csv',
+'SELECT
+  bji.job_name,
+  bji.job_instance_id,
+  bje.job_execution_id,
+  bje.create_time,
+  bje.start_time,
+  bje.end_time,
+  bje.status,
+  bje.exit_code,
+  bje.exit_message,
+  bje.last_updated
+FROM (
+  SELECT job_name, MAX(job_instance_id) AS max_id
+  FROM batch_job_instance
+  GROUP BY job_name
+) latest
+JOIN batch_job_instance bji
+  ON bji.job_instance_id = latest.max_id
+JOIN batch_job_execution bje
+  ON bje.job_instance_id = bji.job_instance_id
+WHERE bje.start_time >= ''2025-10-23 00:00:00''
+  AND bje.start_time <  ''2025-10-23 23:59:59''
+ORDER BY bje.start_time, bji.job_name',
+'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
+);
+</code>