daily pastebin goal
62%
SHARE
TWEET

Untitled

a guest Jan 23rd, 2019 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top