Post reply

SMTP Mail

  • July 14, 2008 at 11:56 pm

    #122376

    hi

    i want to configure smtp mail and i want to automatic mail whenever the backup is success or not success..please help me ..it urgent for me

  • July 16, 2008 at 12:50 am

    #843543

    Hi,

    Create a maintenance plan to execute you're backups.

    The maintenance plan will create a job in the jobs agent. There you can specify to e-mail an operator when the job fails

    regards

  • July 16, 2008 at 1:36 am

    #843572

    for sql server 2005

    Before you configure Database Mail, you need to review the following prerequisites

    1.Database Mail must be enabled

    2.Service Broker needs to be enabled in the Database Mail host database

    do the following:

    1. Configured Database Mail (using SSMS. Management ->database maul. right click - configure db mail wizard ).

    2. Setup SQL Server Agent to use the Profile under the alert system tab.

    3. Created an operator.

    4. Created a job and set to email that operator on failure.

    5. Restarted SQL Server Agent.

  • July 18, 2008 at 3:43 am

    #844876

    thank u

    i want to sent maill to 5 person...please tell how to do

  • July 18, 2008 at 4:16 am

    #844884

    Hi,

    Create a distribution list (exchange level) or create muliple operators

    Kr,

    David

  • August 6, 2008 at 6:34 am

    #853753

    Hi

    We are using SQL server 2000 Enterprise edition in Win 2k Server.

    We have several daily backup and restore jobs which are scheduled at

    various timings.

    I want to configure SMTP mail to send mail/alert automatically whenever the jobs are success/Fail. Kindly let me know what are the things required and how to configure those things.

    Thanks

    Kuma

  • August 6, 2008 at 8:29 am

    #853851

    Hi Kuma,

    Maybe this article can help you: Klik here

    Greetz,

    David

  • August 6, 2008 at 10:50 pm

    #854210

    Hi David,

    Thanks for the link. It is very much informative.

    Thanks

    Kuma

Viewing 8 posts - 1 through 7 (of 7 total)

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