How to create a DML logging table?

you will probably want to log package start/stop times and any errors that occur.

Although the change control table has nice pictures of last event states, it doesn't keep all the history of what happened on a particular object. For that matter, and for error handling, we need another table to host detailed information recorded at the end of each batch job for statistics such as number of inserts, updates, deletes and possible errors occurred on each object.