I often need to know the last time a proc ran and if it finished. So I created a simple table that logs start datetime, end datetime and any error code captured. I'm not sure I'd suggest this for a proc that was going to run a huge amount, I often only need to track ones that might run only every 5 mins at most.