Hi Team,
I have got a requirement from the business users. Could you please provide your suggetsion to achieve this.
We have a batch file thats runs on the schedule time, in that batch file i'm calling a SQL script.
In the SQL script i'm calling a procedure to execute.
Inside the procedure i have the following statement,
Select , Insert and Update commands.
and i'm using OTHER exception to handle the errors.
My requirement is to pass the error messages to the batch file when any of the commands failed to execute and send a mail notification to the group with the error text.
Please provide your suggestion.
Thanks & Regards,
Ramya.