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.
Monit alert script how to#
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.ġ. All the alert actions ( Create SNMP trap, Create command, and mentioned) relate to alert triggering events.
0 kommentar(er)
