Hello guys,
Among other things, we monitor SQL Server and use the published SQL Server template.
In general, we have defined that an action is triggered for each trigger with a certain severity.
Now an SQL server has several databases. If the SQL backup does not work, a trigger is triggered for each database and several actions are generated.
Is it possible to construct triggers in such a way that they only fire if another trigger created from the same prototype has not already fired? In this way, only one action would be created for a central problem.
Many thanks for your help!
Among other things, we monitor SQL Server and use the published SQL Server template.
In general, we have defined that an action is triggered for each trigger with a certain severity.
Now an SQL server has several databases. If the SQL backup does not work, a trigger is triggered for each database and several actions are generated.
Is it possible to construct triggers in such a way that they only fire if another trigger created from the same prototype has not already fired? In this way, only one action would be created for a central problem.
Many thanks for your help!
Comment