SQL server e-mail for tasks

Jonathan Brotto 286 Reputation points
2021-01-05T19:24:26.393+00:00

I am having difficulty to setup automatic e-mails of when the SQL performs a maintenance task. I got the mailer to work during the test. Is there something that needs to be restarted?

53627-mailer-setup-sql.png

53628-sql-mail-server-configure.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,016 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,593 questions
0 comments No comments
{count} votes

Accepted answer
  1. Cris Zhan-MSFT 6,636 Reputation points
    2021-01-06T03:36:10.983+00:00

    Hi @Jonathan Brotto ,

    >There are no operators with email addresses defined on this server.

    Check the email address set for the operator is consistent with the Database Mail Account.

    Here is an article about setting up email notifications for SQL Server maintenance plans/jobs.
    https://social.technet.microsoft.com/wiki/contents/articles/51133.sql-server-alerts-and-email-operator-notifications.aspx

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.