How do you use cloud databases? Take the survey.

Job Agent Alerts For Job Step

FeatherBearFeatherBear Posts: 1 New member
edited September 9, 2022 10:52PM in SQL Monitor
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

Best Answers

Sign In or Register to comment.