Success and Failure notification for Redshift scheduled query

I am able to successfully schedule a redshift query, which is not very fancy. Just simple truncate and load. I also created a SNS topic and attached to this query. I am getting an email notification when this query runs. My question is - Is it possible to customize this email notification with custom body? For eg - In case of failure of this query, I should get an email which says "Redshift scheduled query failed" OR in case of successful completion, it should say "Redshift query was successfully completed".