Joe Kent did give me steps to clear a stuck purge job but I was curious
to know if its possible it tell it its actually running? I do see the
related Queue entry is executing, so it says, but server activity is low
and there doesn't seem to be much server activity from what I can tell.
Purge was started on 5/25 and still shows running. I guess I can try
and clear it but it would be useful to know for certain if its truly not
processing any more.
Joe's steps:
Might give this a try.
1. Disable queues named like wt.router.5.* (e.g. wt.router.5.1
,wt.router.5.2)
2. Stop the method server.
3. Do the following operations from sqlplus while the Method Server is
not running .
select ida2a2, status from purgerecord where name='your_job_name';
update purgerecord set status='failed' where
ida2a2=<ida2a2_from_previous_select>;
commit;
You should then be able to delete the purge job.
