Hello all,
Does anyone configure the database so that it can automatically notify status of the job to the administrator ? Inside the Script, there are many sub sql script. If any of the sub task is fail, I need to notify the administrator.

What is the best tool to accomplish this task ? What are the minimum software requirement needed ?

Your advice is very much appreciated.