Post reply

sql agent mail profile

  • April 12, 2011 at 5:16 pm

    #389260

    We are using sql server 2008. I set up some alerts in SSMS- Sql server agent - Alerts. I created some alerts there - for example I created an alert that has severity 22.

    Then I go to response tab, click notify operators.

    then chose the operators I already set up. (I already setup database mail profile and operators on the server).

    My question is

    1. what will trigger this alert, is it anytime there is an error with severity of 22, it will send an email to the operator?

    2. Do I also need to set up the Mail Profile for SQL Server Agent ?

    I guess sql agent mail profile is when a job step call the alert, but if 1 is true, then it is not called from job step, so I don't need to setup sql agent mail profile, correct?

    Or I have to setup sql agent mail profile in order for any emails sent on this server?

    Confused with why already setup database mail, why need sql agent mail too?

    Thanks

  • April 12, 2011 at 6:45 pm

    #1310770

    Yes,

    Every time that SQL registers an error with the with severity 22, which is a fatal error, then the alert is fired.

    In order for you recieve and email when that aler fires, you have to do the following:

    1) Configure Database Mail on the server

    2) Configure the Agent Alert System (on SSMS Right Click on Agent --> Properties --> Alert System)

    3) Configure your operators

    4) Configure your alerts.

    I think that you are only missing step 2 (configure the agent)

    Look at the screenshot:

    QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809

  • April 13, 2011 at 10:26 am

    #1311168

    Thank you, that answers my question.

    I did miss the second step, because I thought I already set up other steps, and also input email on the notification tab for alert.

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

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