Spring Boot Batch Example

Database schema SQL statements

CREATE SCHEMA family;
CREATE TABLE IF NOT EXISTS family.person(id SERIAL NOT NULL, first_name TEXT NOT NULL, last_name TEXT NOT NULL, PRIMARY KEY (id));
INSERT INTO family.person(first_name, last_name) VALUES ('Volodymyr', 'Prokopyuk');
SELECT * FROM family.person;

Spring Batch Job Execution status SQL query

SELECT ji.job_instance_id, ji.job_name, -- Job Instance
    je.job_execution_id, je.start_time, je.end_time, je.status, je.exit_code, je.exit_message, -- Job Execution
    jep.key_name, jep.type_cd, jep.long_val, jep.double_val, jep.string_val, jep.date_val, -- Job Parameters
    jec.short_context, jec.serialized_context, -- Job Execution Context
    se.step_execution_id, se.step_name, se.start_time, se.end_time, -- Step Execution
    se.read_count, se.write_count, se.commit_count, se.rollback_count, -- Step Execution counts
    se.status, se.exit_code, se.exit_message, -- Step Execution status
    sec.short_context, sec.serialized_context -- Step Execution Context
FROM batch_job_instance ji
    LEFT JOIN batch_job_execution je ON je.job_instance_id = ji.job_instance_id
    LEFT JOIN batch_job_execution_params jep ON jep.job_execution_id = je.job_execution_id
    LEFT JOIN batch_job_execution_context jec ON jec.job_execution_id = je.job_execution_id
    LEFT JOIN batch_step_execution se ON se.job_execution_id = je.job_execution_id
    LEFT JOIN batch_step_execution_context sec ON sec.step_execution_id = se.step_execution_id
ORDER BY ji.job_instance_id DESC, je.job_execution_id DESC, se.step_execution_id DESC

volodymyrprokopyuk/spring-boot-batch-example

Spring Boot Batch Example