By Navratan Verma
Let us quickly learn how to setup database email by using your gmail account. (Applicable to SQL 2005 onwards)
Download Script Here. SetupDB_Email
Enable the Database email feature.
Setup Profile and add account.
In case of gmail make sure you enable the option Allow less secure apps : ON
under Sign in and Security -> Connected apps and Sites.
Send the Test Email.
Finally do a cleanup, remove Logs using Date parameter relevant to your time and delete account and profile.