Has anyone modified the DBSS_Jobs_Failed rule to set criteria for a specific job?

The DBSS_Jobs_Failed rule generically checks for job failures.  I want to copy the rule and set up a rule to monitor a single job containing the string %backup% in the job name.

Parents
No Data
Reply
  • Thank you. This was exactly what I needed. Now I have 2 more issues to work through.

    1. One of the variables I need to add is the instance name so that it can be used in an email,
    2. The job fires for the same failure upon every check. I think I need to change this event driven so it only fires upon failure. Does that sound about right?

    Also, do you know if there is documentation about the topology types and the associated property values to make it easier to find what I need for variables?
Children
No Data