Page History
These The Specify Alert Criteria windows allow you to use words, phrases, and wildcards to further define your alert rule criteria. For example, you can use this window to find and alert on all databases in your environment that use a naming convention such as "dbname01".
Available actions
Alert on objects whose names match the listed words, phrases, or wildcards
...
Use the following examples to help you define wildcard match criteria. Note that wildcard matches are not case-sensitive.
| If you want to match … | Use … | Examples |
|---|
| One digit | # | You want: All databases with name of testNN | You specify: test## | You get: Test00Test01test#1 |
| One character | ? | You want: All databases with name of testXX | You specify: test?? | You get: Test00Test01TEST?htester |
| Any character | * | You want: All databases that start with test | You specify: test* | You get: Test00Test01test0101test4metest#1TEST?htest*devtestertest |
<Alert criteria> to match
Allows to you change the list of match criteria. You can add a new criterion or remove an existing criterion.
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Compliance Manager audits all activity on your server. Learn more > >
...
...