Job Agent Alerts For Job Step

FeatherBear

I know there is a way to setup an Alert for when a Job Agent Job Fails. Is there a way to setup an alert for when a the Job finished successfully but one of the steps failed?

For example we have a job with 12 steps that run different warehouse procedures and SSIS Packages that are standalone. Because they aren't dependent the job is setup to allow all steps to be run regardless if the previous step failed. This allows for us to ensure all reports using the different datasets have an equal opportunity of being refreshed nightly no matter the order each is run. By setting up an alert I wouldn't have to check each of the jobs that work like this manually (or at least via the Job Agent Tab).

Thanks

Kurt_M

Hi @FeatherBear

As we only have the "Job cancelled", "Job duration unusual" and "Job failing" alert options, my suggestion would be to set up a custom metric & alert to cover what you'd like:



Using this helpful thread, you could potentially use one of the queries in here to use as a base to construct a query that would work for your setup. 
https://stackoverflow.com/questions/3858472/notify-operator-if-any-step-in-job-fails

Kurt_M

Documentation on creating a custom metric & alert can be found here:

https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/adding-custom-metrics-and-alerts