Database Mail – test is OK, but jobs do not notify

  1. Run SQL Server Management Studio.

  2. In Object Explorer, expand the server.

  3. Right-click on the SQL Server Agent and then click its Properties.

  4. Click Alert System.

  5. Check Enable Mail Profile.

  6. In the Mail system list choose Database Mail.

  7. In the Mail profile list select a mail profile.

  8. Restart the SQL Server Agent

Good Luck!

Advertisements

One Response to Database Mail – test is OK, but jobs do not notify

  1. Rocky Spell says:

    Im obliged for the blog. Keep writing.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: