I am trying to create a notification to alert users when a new opportunity is created via email. The notification works as expected, however it continues to fire every time the escalation service runs. Traditionally we have achieved the same result with an escalation rule which updates a field within the entity to mark the email as being send.

Is there a way for a notification to run only once? Unlike escalation rules it is not possible to set a marker in the database to state that the notification has already been run? For email notifications an escalation rule is quite cumbersome and I was hoping to use notifications as a cleaner way to send emails.