error | select count(*) as error_count
* | select hour(now()) as hour limit 1
($1.error_count>100 && $2.hour>=9 && $2.hour<=18 ) || ($1.error_count>10 && ($2.hour<9 || $2.hour>18))
$1.error_count>100 && $2.hour>=9 && $2.hour<=18
indicates to trigger an alarm when error_count
exceeds 100 between 9:00 AM and 6:00 PM, while $1.error_count>10 && ($2.hour<9 || $2.hour>18)
indicates to trigger an alarm when error_count
exceeds 10 between 7:00 PM and 8:00 AM.
문제 해결에 도움이 되었나요?