Send notification upon SQL failure

Question

Hi all,

I have a stored procedure in aurora MySQL, this stored procedure is called from my aws glue job.

Is there any way to generate a notification if the stored procedure fails?

So i want to be notified if the invoked stored procedure fails

Thanks.

Answer

If the failure of your stored procedure leads to failure of Glue job, you can use Amazon EventBridge to detect the Glue job failure and send a notification to one of the available targets.

A sample Amazon EventBridge rule:

{
  "source": ["aws.glue"],
  "detail-type": ["Glue Job State Change"],
  "detail.state": ["FAILED"],
  "detail.message": [{
    "prefix": "JobName:MyJob and"
  }]
}

If your Glue job result doesn't rely on stored procedure result, you can then use Python AWS SDK to send an email notification.

A sample Amazon EventBridge rule:

```
{
  "source": ["aws.glue"],
  "detail-type": ["Glue Job State Change"],
  "detail.state": ["FAILED"],
  "detail.message": [{
    "prefix": "JobName:MyJob and"
  }]
}
```

If your Glue job result doesn't rely on stored procedure result, you can then use [Python AWS SDK](https://docs.aws.amazon.com/ses/latest/dg/send-an-email-using-sdk-programmatically.html) to send an email notification.

Send notification upon SQL failure

Relevant content