Post reply

SQL 2008 help? Why the job notification doesn’t send the email to operator?

  • March 11, 2009 at 6:27 pm

    #128558

    SQL 2008

    I setup a job to run database backup and set the notification to email to operator ‘SQLGrp’ when the job completes. I find the mail in sysmail_allitems with a status of sent. But operator SQLGrp never receives the email from the SQL job. It works with SQL 2005 but not with SQL 2008.

    I tested database mail using the following query and operator SQLGrp can receive the email. The database mail seems work well.

    EXECUTE msdb.dbo.sp_notify_operator @name=N'SQLGrp',@body=N'testing SQL notifications'

    EXEC msdb.dbo.sp_send_dbmail

    @profile_name = 'SQLAlert',

    @recipients = 'SQLGrp@abcd.com',

    @body = @Desc,

    @subject = 'Test database mail'

    Could anyone advise me why the job notification doesn’t send the email to operator? It works with SQL 2005 but not with SQL 2008.

    Thanks very much in advance for your kind help!

  • January 20, 2011 at 10:00 am

    #1276054

    Did you ever get this resolved? I am running across the same issue. SEND TEST E-MAIL works in the DB Mail Configuration but the Notifications are not working.

  • January 20, 2011 at 10:19 am

    #1276072

    Did you enable the Mail Profile on the SQL Server Agent? Go to SQL Server Agent Properties and then the Alert System page and check the Mail session settings.

  • January 20, 2011 at 11:04 am

    #1276127

    Thanks for the reponse! I forgot to update my post. I ended up finding that I had that unchecked. I went ahead and checked that and restarted the SQL Server Agent and I was good to go.

    Thanks again for your response! Everyone in here has been so helpful and great. 🙂

  • January 20, 2011 at 11:13 am

    #1276132

    Thank you! It works.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply