Send notification upon SQL failure

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.