Skip to content

Instantly share code, notes, and snippets.

@nervouswiggles

nervouswiggles/407_SQL scripts to cleanup the QRTS tables

Last active August 29, 2015 14:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nervouswiggles/e9f7c108d1757c580c49 to your computer and use it in GitHub Desktop.
Save nervouswiggles/e9f7c108d1757c580c49 to your computer and use it in GitHub Desktop.
Download ZIP
Data is Stale - OIM 11g Database manipulation to cleanup the scheduled tasks. Check out https://technicalconfessions.com/posts.php?post_id=407
Raw
407_SQL scripts to cleanup the QRTS tables
select * from JOB_HISTORY where job_name = 'PUT_YOUR_SCHEDULE_TASK_NAME_HERE';
delete from JOB_HISTORY where job_name = 'Student CRN Cleanup Task';
commit;
delete from QRTZ92_FIRED_TRIGGERS where TRIGGER_NAME in (
select trigger_name from QRTZ92_TRIGGERS where JOB_NAME ='PUT_YOUR_SCHEDULE_TASK_NAME_HERE');
commit;
delete from QRTZ92_SIMPLE_TRIGGERS where TRIGGER_NAME in (
select trigger_name from QRTZ92_TRIGGERS where JOB_NAME ='PUT_YOUR_SCHEDULE_TASK_NAME_HERE');
commit;
delete from QRTZ92_TRIGGERS where JOB_NAME ='PUT_YOUR_SCHEDULE_TASK_NAME_HERE';
commit;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment