Share via

SQL Agent Notify Database mail

Ismail Cassiem 226 Reputation points
2021-01-22T23:47:58.483+00:00

Hi,

I have set on my job failure to notify via database mal to an operator
now i have activated the email to sms service provider gateway but unfortunately the number for cell is in the SUBJECT but operator or database email had no property fr this

any ideas, please elp?

regards

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,150 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,321 Reputation points Microsoft Vendor
    2021-01-25T06:58:23.743+00:00

    Hi @Ismail Cassiem ,

    Please check if you missed some steps when setup SQL Server alerts and email operator notifications.

    1. Setup SQL Server Database Mail
    2. Define a SQL Server Operator
    3. Setup SQL Server Agent Settings
    4. Restart SQL Server Agent to Activate Settings
    5. Define a SQL Server Alert
      6.Verify SQL Server Alert is Working

    Please refer to the blog How to setup SQL Server alerts and email operator notifications to get more detail steps.

    Best regards,
    Cathy Ji

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    1 person found this answer helpful.
    0 comments

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.