As part of a client maintenance process we need to delete some objects (including queues).
I have written the code to delete the objects through the API but some of those objects are queues. Before I delete these i think it need to cancel and deactivate everything attached to it?
Is there an easy way to do this rather than having to find all those objects and cancelling them one by one? If this has been deemed ok to delete then I do not care what is running (if anything).against the queue.
If I have to do the latter, again is there any easy way to get all the top level run ids (activators/parents) that I can feed into CANCEL_UC_OBJECT()?
I would create a SQLI VARA searching for all objects contained in the queue
select eh_name, eh_ah_idnr, eh_status, eh_starttime from EHwhere eh_client = 1and eh_queue = 'MYGREATQUEUE';
and use the scriptcommands below to cancel all running objects, deactivate them and stop the queue and remove it (if necessary)
Cheers Wolfgang, will give it a whirl.