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 questions

fail a glue job if the called stored procedure fails

output log for RDS stored procedure

Call a redshift stored procedure with dynamic parameter from boto3 lambda

Invalid operation when creating Stored Procedure

Programmatically Running a Stored Procedure in Redshift

Call a stored procedure in Redshift from Glue

Trigger stored procedure upon glue job succe

Performance of Redshift Stored Procedure is not upto mark

call a stored procedure from within glue job

Send notification upon SQL failure