Failure to notify user of completed Job

Susja 716 Reputation points
2020-09-23T16:18:46.427+00:00

Hello.
I'm using Windows 2016 and MS SQL Server Management Studio 18.6
I created a Job and want to be notified when it completes.
I created Mail account and profile. Email Test works fine. I created a Job for backup. In Job 'properties' I selected Email box and provided my profile and be notified when Job completes.
The problem is that it does not notify me when Job completes.
In Job history I see the following line:
Message
The job succeeded. The Job was invoked by User starlimsconsole. The last step to run was step 1 (starlims_database_diff_backup). NOTE: Failed to notify '<My Name.' via email.

What could be the issue?
Thanks

Azure SQL Database
0 comments
Accepted answer
  1. Susja 716 Reputation points
    2020-09-29T23:51:49.863+00:00

    @Mike-Ubezzi-MSFT
    I wanted to change the SP as you suggested but realized that I don't have permission to change.
    Hence I gave up on email notification task using Job notification.
    I simply implemented ETL in Task Scheduler which checks for Job Status. It will meet my need and notify me about Status of the Job.
    BTW: I noticed today in Error Logs the following:
    Message
    [298] SQLServer Error: 14613, The specified '@recipients' cannot use commas (,) to separate addresses: 'Smith, John'. To continue, use semicolons (;) to separate addresses. [SQLSTATE 42000]

    I assume it could be the reason why it did not work for me. But anyway ... I have a workaround by using ETL
    Thanks again

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mike Ubezzi 2,776 Reputation points
    2020-09-25T02:12:02.32+00:00

    Hi @Susja - Can you please review the following document to ensure you have SQL Server Database Mail configured correctly. There is a Database Mail Configuration Wizard you can leverage to walk you through the process, to ensure you have it set correctly. Please see: Configure Database Mail. This feature is not supported in Azure SQL Database but is supported by Azure SQL Managed Instance and SQL Server on an Azure VM or SQL Server on-premise.

    From the error it appears there is an entry for your email that has not been set. Please doublecheck your solution and see if there is a missing entry.

    1 person found this answer 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.