Hello,
Im pretty sure this is an EEBKAC error but Im out of ideas.
check_id action_id action_every_failure action_recovery action_repeat_period_minutes action_hourly_limit action_template_id date_created date_updated
-2 -8 1 0 1 60 -2 2023-11-09 20:38:22.607 2023-11-09 20:44:40.067
23 -1 1 0 5 12 -2 2023-12-02 00:01:17.703 NULL
157 -1 1 0 5 12 -2 2023-11-10 19:04:15.067 2023-12-01 19:18:34.233
165 -1 1 0 5 12 -2 2023-12-01 19:18:29.713 NULL
Ive got a few checks setup to send an email when triggered. One of them is a test database and the check is for the state. To test Ive taken the database offline and no message is sent.
I have tested the command from the [sqlwatch_config_action] table and the email does send out.
What is the process for manually running the jobs that would run the check and process the action? The sqlwatch-internal-checks runs fine, and ive executed sqlwatch-internal-actions inbetween its schedule to test.
Any help is appreciated! Thanks!