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.

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.

 

 

 

 

 

 

 

Tags:

No comments yet.

Leave a Reply

%d bloggers like this: