Daniel,

Provided this is not high-velocity stuff, but is fairly rare, you could add
an ON INSERT trigger to your audit table.  That trigger could then do
something such as:

1. Use sp_send_dbmail to email your group
2. Use sp_start_job to start a SQL Agent job that could do whatever you
want, including sending the email.
3. Use RAISERROR to raise an alert that is configured to email, page, etc,
whoever you want to have know about this.

And so on.

If the errors were frequent it would probably be better to skip the trigger,
but create a scheduled job that occasionally runs (every hour?) and reports
on recent activity.

RLF