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,117 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,583 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 21,111 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 No comments