If you want to call a hook after the backup is done I think you’d need to create a plugin.
Are you really suggesting that a failed backup is how you want to know if Discourse is down?
/srv/status gives you a pretty good idea, though Discourse can break in ways that aren’t reflected by that. It will indicate if the database is broken.