By using AWS re:Post, you agree to the Terms of Use
/Send notification upon SQL failure/

Send notification upon SQL failure

0

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.

1 Answers
0

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.

SUPPORT ENGINEER
answered 4 months ago
EXPERT
reviewed 4 months ago
  • This is not working. I need to apply this SNS setup for jobs starting with a specific prefix. There are around 30 jobs, how can I accomplish using this prefix attribute?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions