...
| Code Block |
|---|
select * from grouper_loader_log where lower(job_name) like '%abc%' order by started_time desc; select * from GROUPER_QZ_TRIGGERS where lower(trigger_name) like '%abc%'; select * from GROUPER_QZ_CRON_TRIGGERS where lower(trigger_name) like '%abc%'; select * from GROUPER_QZ_FIRED_TRIGGERS where lower(trigger_name) like '%abc%'; select * from grouper_qz_job_details gqjd where lower(GQJD.JOB_NAME ) like '%abc%'; |
If you want to unschedule BLOCKED jobs (the code part is one line of GSH)
| Code Block |
|---|
GrouperSession.startRootSession();
for (String triggerName : HibernateSession.bySqlStatic().listSelect(String.class, "select trigger_name from GROUPER_QZ_TRIGGERS where trigger_state = 'BLOCKED'", null)) {GrouperLoader.schedulerFactory().getScheduler().unscheduleJob(org.quartz.TriggerKey.triggerKey(triggerName));} |
If you get errors about a database quartz job, you can unschedule with (or whatever the trigger name is):
...