I need to set up an audit failure notification system or job that alerts or notifies specific users from SQL Server Management Studio on SQL Server 2014.
SQL Server or software monitoring SQL Server must provide an immediate real-time alert to appropriate support staff of all audit failure events requiring real-time alerts.
Configure the system to provide an immediate real-time alert to appropriate support staff when a specified audit failure occurs.
Any ideas in a simple or easy way?
I am not good at scripts.....please explain through as possible. Any suggestions?