To include the custom alert action profile, set it within the Configuration subsystem in corresponding field: The list of available alert actions profiles can be reviewed (and edited, if needed) after saving:īesides custom alert action profile, there are two other, pre-defined profiles: ApexSQL deadlock info and ApexSQL deadlock info. In both cases, after successful execution, the message will appear:Īfterwards, the alert action profile My custom alert can be saved, modified according to the needs and used further. If the action tags are included in a script, the Select tags modal dialog will appear (for this case, the %Server% action tag is selected): This panel consists of two components: the SQL script input field and preset action tags (below).Īction tags like Server full name, Alert severity and others are parameters which can be used in the script composition, and they represent the information that retrieves directly from the alerting event.Īfter the input of a desired SQL statement, press the Test button. Initially, user will be prompted to add an email profile, by default.Įlements of the SQL script execution panel Name the new alert action profile My custom alert, and select Create SQL script option: Then, add a new action profile, as in the picture below: To use the SQL script alert action, first choose a desired SQL Server instance, and navigate to the Configuration subsystem and Alert actions tab. How to create a SQL script alert action in ApexSQL Monitor These custom actions in alerts won’t be fired if there is no alert activity.ġ. Microsoft standard iconography, colors and other visual effectsĬomparison was conducted on March 19, 2020ĭisclaimer: All product and company names are trademarks ™ or registered ® trademarks of their respective holders.All the alert actions ( Create SNMP trap, Create command, and mentioned) relate to alert triggering events. Serial script execution on multiple databases Possibility of script execution on its own connection
Parallel script execution on multiple databases Change the execution order of the scriptsĮxecuting multiple scripts on multiple databases
0 kommentar(er)
