Masterplan AX 2012 - Deleting Static plan duration

Hello,

We have had our MRP Static regeneration crash on us, which appears to have left allot of spurious reqtrans / reqtranscov records.

The delete plan usually takes 3-4 minutes, now has been executing for 1hour.

Could anyone shed some light on how i can determine if the delete plan is actually processing.

Also does anyone have an idea how we could delete the plan, without using the “Delete plan” within AX? Eg: TSQL…

Any help / suggestions would be greatly appreciated.

Thanks