Post reply

database mail 2005

  • May 15, 2009 at 5:24 am

    #155710

    How can i set mail alerts using database mail if a job fails.Database mail is correctly configured

  • May 15, 2009 at 6:00 am

    #995215

    Did you configure SQL Agent to use the mail profile?

    http://msdn.microsoft.com/en-us/library/ms186358(SQL.90).aspx

    [font="Verdana"]Markus Bohse[/font]

  • May 15, 2009 at 7:18 am

    #995296

    configuring SQl Agent means.??????i didnt get you

  • May 15, 2009 at 7:40 am

    #995323

    Right click on SQL Agent select properties and then Alert System ensure Enable Mail Profile is checked and there are the correct values in the Mail system and Mail profile fields.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • May 15, 2009 at 7:49 am

    #995335

    shanila_minnu (5/15/2009)

    configuring SQl Agent means.??????i didnt get you

    Did you look at the link I added????

    [font="Verdana"]Markus Bohse[/font]

  • May 15, 2009 at 8:02 am

    #995352

    thank u....it was disabled...now i enabled it...since this is a production server i cant restart the sql server agent now...will let u know if u have more queries

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

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