Problem
You configure SQL Server Maintenance Plan and set it to e-mail you when the job is complete. When you check the job history, you notice that it fails to send the e-mail and the following message is logged:
Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile is configured. Specify a profile name in the @profile_name parameter.
Solution
Configure your Database Mail settings.
- Open SQL Server Management Studio
- Connect to your SQL instance -> Management
- Right click on Database Mail -> Configure Database Mail -> Next
- Select the option to ‘Set up Database Mail by performing the following tasks:’
- Type a Profile Name and description
- Under SMTP accounts, click Add
- Type an Account Name and Description
- Enter an e-mail address to send from:
- Enter a display name to send from:
- Enter your Reply-email address (optional)
- Enter your SMTP server name
- Select Windows Authentication using Database Engine service credentials (If you are using Windows authentication). Otherwise, select the option that suits your environment.
- Click OK to save your settings
- Under Public profile, set your newly created profile to both Public and default.
- Click Next and finish the wizard.
- Now right click on Database Mail again and select Send Test E-mail. Send an e-mail to yourself to ensure that your e-mail notifications are working properly.
