Dear all DB expertist,
right now we have a system workflow monitoring tools called control-M, all our housekeeping job is running in a store procedure and we can see the the exeception flow control is not very good.
How can we improve the execeptional flow control the return as much information as possible when the SP failed to the monitoring system ? the Control-M.
All solution is welcome and I will try it one by one.