A Manual Unmerge job must complete with a RUN_STATUS of 0 (Completed Successfully) or 1 (Completed with Errors) to be considered successful.
The CMXUT.DROP_TEMP_TABLES stored procedure must be executed after any procedure that returns OUT_TMP_TABLE_LIST in order to clean the temporary tables.