Clearing a purge job (9.1)

[avillanueva]

Anyone know how to stop and clear a running purge job that I believe not
to be running? Purge Manager says its In Progress and Event Manager
shows it as Pending. It would seem to me that there is a block on it,
that its waiting for something else, right? I cannot delete these
entries from the UI since you get a pop block message. Cannot delete
items that have that status. I do not believe it is doing anything. Is
there something from the Queue Manager I can do?

[jkent]

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.