Tuesday, January 14, 2014

SQL Server 2012 setup job notification by email

Step by step procedure

How to setup job notification by email on a newly installed SQL Server 2012.

  • Setup Database Mail
  • Create an operator for SQL server Agent
  • Setup notification in the job properties

Setup Database Mail

First check with your mail administrator what the outgoing mail server is and if you need a real email account for the outgoing email or if a dummy email address will suffice.image

image

image

image

image

image

image

image

image

Next screen click finish

Next screen: success message, click Close

Create an operator for SQL server Agent

image

image

Select properties

image

image

No comments: