help required to set up email notification to failed jobs(urgent)

  • Hi

    Iam very new to SQL Server 2005 and I was asked to set up an e-mail notification for the job failure. We are in the process of migrating data bases from 2000 to 2005 and we migrated all the jobs and we need to set up e mail notification on job failure . I have gone across all the msdn forums but iam unable to set it up.

    Can any one give step by step guidance to configure data base mail and then stting up an e mail notification for the failure jobs

    please its really very urgent

    thankyou

    posani

     

  • Lookup "Database Mail" in Books Online to set up email to work from SQL 2005 (there are several "See Also" topics under it).

     

    For notifications for a job go properties for the job and look under notifications (after you set up the Operator to send it to).

  • Hi Dude,

              Regarding DBMail pls refer the below link,it gives the step by step methods to configure the mail,

    http://www.sql-server-performance.com/da_email_functionality.asp

    Cheers

    Deepak

     

    [font="Verdana"]- Deepak[/font]

  • Thanks a lot to every body iam able to configure it and send mails

    looking for all your support for my future challenges in  sql server

    thankyou

    pavan posani

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

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