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.

Manu_G · 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