Maintenance plan SQL Server 2014

0

I created a maintenance plan in the bank of the company where I work, it is dealing with the following options:

  • Check Database Integrity
  • Shrink Database
  • Reorganize Index
  • Rebuild Index
  • Update Statistics

And after completing it, he sent the email to a registered operator, at the first moment he was giving the following 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.

This problem I solved leaving the public operator and the default profile, according to the execution history there is no more type of error, even so I am still not receiving email after the process execution, could someone help me ?

    
asked by anonymous 20.01.2016 / 20:04

1 answer

0

Make sure you do not have any blocked e-mail ports on the server. Another option is also to look at the "mail queue" of the server that is sending the email. You might be rejecting it for some reason you'll check it out.

    
28.01.2016 / 22:30