I was wondering if anyone has created an stored procedure for clearing stuck batches. If it's driven by batch name and possibly user it should be pretty safe to do right?
These are the queries used to clear batches that I have found. I figure I can write an SP with parameters to run all of these.
delete
from DYNAMICS..SY00800
where bachnumb = 'SOMEBATCH'
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='SOMEBATCH'