Search This Blog

SQL Maintenance Plan error “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.”

Some body have this error : 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. When i execute my maintenance plan.

 

Resolution

The issue is related to the default email profile, you have to set a default email profile in order for the maintenance plan send the email alert.

 

Please Follow These steps to Resolve this Problem

1. Go to Database mail

2. Right Click  Click on Configure Database mail.

3. wizard will click next

4.select Manage Profile security

5. Click Next

6. Beside Profile name  by default there will be no , Please make it yes

7. Finish

No comments: