Comments
2 comments
-
Hi @...
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
-
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
Add comment
Please sign in to leave a comment.
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