[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 718
  • Last Modified:

How to raise an email alert if job or step within job fails

Hi,
I have number of SQL agent jobs. Certain jobs have more than 10 steps within them.

I wish to have an email ALERT raised when step/job fails with full error details embedded within alert email.

What configuration do I need at attached options?

2014-02-06 13_32_01-Job Properties - IndexOptimize - USER_DATABASES.jpg
0
crazywolf2010
Asked:
crazywolf2010
  • 2
1 Solution
 
Surendra NathTechnology LeadCommented:
choose alerts from the menu

And then click on the new button, that will guide you to create a new alert...
Within that in the options you can tick on the e-mail option.
0
 
Surendra NathTechnology LeadCommented:
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now