In Just continuation of my Previous POST, I am writing this to share how to fire an email from SQL Query that you can further use in your Stored Procedures.
Query that you need to write is –
Above Query will send an Email to the the Recipients you added in the Query. Make sure you have configured your email Properly as explained in the previous Post otherwise you will end up with an error.
Now to see the Logs of the Emails sent you can open – View History Log.
This will open the the Window where you can trace each and every logs along with the Error messages
In the left Panel you will find each and every options for Auditing.