Test alert


Job details

Name: Test alert
Platform: Sqlserver
Category: Availability
Description: Test alert that alerts every ‘X’ minutes.
Long description: Test alert that alerts every ‘X’ minutes. Useful for testing extensions and not intended for use in production environments.
Version: 1.0
Default schedule: 5,15,25,35,45,55 * * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2000′ & hasengine=‘YES’ & (engine_edition = ‘Microsoft SQL Server’ engine_edition = ‘Azure SQL Managed Instance’)]

Parameters

Name Default value Description
Time between warnings 180 The time in minutes between each alarm message.
Time between alarms 360 The time in minutes between each alarm message.
Warning message Test WARNING The message to send if we send a warning message
Alarm message Test ALARM The message to send if we send an alarm message
Ok message Test OK The message to send if we send an OK message
Disable warnings NO Enables/disables warnings. YES or NO values
Disable alarms NO Enables/disables alarms. YES or NO values

Job Summary

SELECT histr_date, type_message FROM dbw_test_alert_history ORDER BY histr_date DESC

Job Configuration

Implementation Details

Reporting

The setup and operations in this job are specifically configured to support non-production environments, where they can help in validating the behavior of alert management systems without impacting actual operation timelines and data security.