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