Job Alerts using SQL Server Agent

• A Little Help Please

  SSCarpal Tunnel

  Points: 4764

  More actions

  February 26, 2009 at 1:55 am

  #128092

  I know im half way there!

  I have configured 'Database Mail' and enabled the correct 'Mail Profile' under SQL Server Agent Properties. (DB Mail works)

  Now how do I create an alert to inform me, vai email, when a job completes?

  Thanks

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  February 26, 2009 at 2:01 am

  #950462

  You may want to do the following.

  1. Create an Operator

  2. Specify the Email ID for the Operator

  3. Select the appropriate options under "Notifications" tab of the Jobs, for which you want to be alerted.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga