Skip to content

Instantly share code, notes, and snippets.

@gnosis23

gnosis23/batch.sql

Created May 19, 2014 05:55
Show Gist options
  • Save gnosis23/2d76c968f7681b36765e to your computer and use it in GitHub Desktop.
Save gnosis23/2d76c968f7681b36765e to your computer and use it in GitHub Desktop.
Download ZIP
spring batch
Raw
batch.sql
select
b.*
from batch_job_execution_params b
where b.job_execution_id in (
select a.job_execution_id from BATCH_JOB_EXECUTION a where end_time is null);
update BATCH_JOB_EXECUTION t set t.end_time = SYSDATE where t.job_execution_id = '1581'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment