truncate wf_jobs and wf_actions tables...

[Miguel Lucero <Mi...@apollogrp.edu>]

Hello,

I was wondering if anyone knows how I can truncate or purge WF_JOBS and WF_ACTIONS for a given date range. I know oozie will automatically purge records for killed jobs but it does not do that for those that are still running. I have an active dev db that's filling up a disk and as a workaround I'd like to purge some of those records. Has anyone on this list ever had to handle this problem before and would anyone have the query for safely truncating that data? I apologize if I'm approaching this the wrong way and would appreciate any guidance you all might be able to provide...

thanks

-ml


________________________________
This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system.