Make a function where you could setup a before/after Commit and before/after Get stored procedure which will be executed automatically.

In my case I backup the Database diagrams to table with a stored procedure. I would like to run it before every commit. The restore sp could be run after a get