Place it right after a reveal goes wrong, then follow it with the classic error sound to underline the mistake. For extra drama, add dun dun dun just before it, so the alert lands as the payoff to a build-up.