How to configure automatic email notification when jobs scucced

• SQL Galaxy

  One Orange Chip

  Points: 29478

  More actions

  September 26, 2008 at 3:07 am

  #77094

  Hi SQL Experts

  pls give me,

  How to configure automatic email notification when jobs scucced in sql server 2000.

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  September 26, 2008 at 4:04 am

  #877527

  Do you have outlook configured on your server?

• SQL Galaxy

  One Orange Chip

  Points: 29478

  More actions

  September 26, 2008 at 5:22 am

  #877555

  thanks for reply..

  yes, we have

• Buxton69-502449

  SSCrazy

  Points: 2026

  More actions

  September 26, 2008 at 6:32 am

  #877604

  You need to configure SQL Server to use SQL Mail, configure and Operator with an email address and then in the notifications tab of the job in the email box enter the Operator.

  Setting up the mail is the most tricky part but there is a guide in sql server central and here is a KB on how to do it:

  http://support.microsoft.com/kb/263556