Guest User

Untitled

a guest
Jan 23rd, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. DELETE FROM batch_step_execution_context bsec
  2. WHERE
  3. EXISTS (
  4. SELECT 1 FROM batch_step_execution bse
  5. join batch_job_execution bje on bje.job_execution_id = bse.job_execution_id
  6. WHERE bje.start_time < current_date - 14 and bsec.step_execution_id = bse.step_execution_id);
  7.  
  8. vacuum batch_step_execution_context;
Add Comment
Please, Sign In to add comment