Post reply

sp_send_dbmail Won't fire off email within SQL Agent

  • December 19, 2013 at 12:22 pm

    #281499

    I can run the t-sql statement in management studio and I receive an email as expected using sp_send_dbmail

    I cannot get sp_send_dbmail to work within a job. Notification emails are working within jobs so I am certain email is working to that extent.

    I have changed the job owner to the account that is running SQL Server Agent and the account has sysadmin privileges.

    I am running out of things to check.

    Any suggestions?

  • December 24, 2013 at 3:24 am

    #1675749

    Are you using dbmail inside job step and checking?

    if it is can u post the code you are checking(after masking).

    Regards
    Durai Nagarajan

  • January 3, 2014 at 7:15 am

    #1677266

    You've not given us any code, but is the email portion of your job a step of it's own? If so, do you have the database set to MSDB?

  • January 6, 2014 at 2:32 am

    #1677670

    Hi,

    Verify that you have enabled mail profile on the Alert System. This is on SQL Agent properties.

    Regards

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

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