execution step logging

Question

Hi All,

I would like to know how to handle each and every step executing on table and to log them into one logging table.

e.g, I have one master SP which is calling 10 other child SP, so to log each step

1. master sp is getting executed

2. child sp is executing,

• 2.1 - 10 rows inserted
• 2.2 - execution completed

3. master sp executed successfully 

to log execution steps in detailed

 

Thank you