Workflow Error - Send email

Hi Robert,

You can achieve this using one of below technique :

1) In SQL procedure use try catch to detect the exception on success execution send string “Success” and on exception send string “failure”

In your workflow take two parallel lines connect one line with you default activity (having line rule to check if stored procedure return success string) and another line with new activity having email Event(having line rule to check if stored procedure return failure string).

Now if you’re Stored Procedure fails because of Exception block it will return “failure” string and line rule force flow to send email.

 2) You can use code in Exception rule to send email.

             System.Net.Mail.SmtpClient MailServer = new System.Net.Mail.SmtpClient(K2.StringTable["Mail Server"]);

            from = “from Address";

            to = "to address";

            System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage(from, to);

            message.Body = "Exception occurred";

            message.Subject = "Task Failure Notification ";

            MailServer.Send(message);

let me know if this helps you.