Share via

SQL Server Audit - Get email Notification

DataNerd 21 Reputation points
2022-10-25T16:59:04.33+00:00

Hello,

I have a SQL Server audit configured and running on 2016 SQL Server. I am trying to find a way to send an alert if the audit failed for any reason, thank you for your help.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,601 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,131 Reputation points Microsoft Vendor
    2022-10-26T02:48:02.953+00:00

    Hi @DataNerd ,

    You can create an appropriate alert by utilizing SQL Server Agent jobs. Please refer to below blog to get detail information.

    SQL Server auditing – how to be alerted about important auditing events

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    1 person found this answer helpful.
    0 comments