-
Re: Test fire alert schedule for 9pm every night?
Leon AdatoJul 4, 2013 9:01 AM (in response to mprice501)
Set up a custom SQL alert that calculates the time and if it's between 9:00 and 9:05, triggers an alert. And if it's NOT that time, it resets.
I know that's shorthand. Let me know if you need help with the SQL itself.
-
Re: Test fire alert schedule for 9pm every night?
Leon AdatoJul 4, 2013 9:12 AM (in response to mprice501)
Meh, I got curious. What it should look like is something like this:
Custom SQL alert
using the Nodes table
(in the box where you put your code):
where nodes.nodeid = 1 (just so you don't kick this trigger for every node in the database)
and convert(varchar(10), GETDATE(), 108) >= '10:00:00'
and convert(varchar(10), GETDATE(), 108) <= '10:11:00'
This will return ONE row only between 10:00 and 10:10. Your reset would just be
and convert(varchar(10), GETDATE(), 108) > '10:11:00'
That would kick an alert once a day at 10:00.
-
Re: Test fire alert schedule for 9pm every night?
mprice501 Jul 10, 2013 6:12 PM (in response to mprice501)
Cheers dude, I am using page gate for text alerts now, can schedule 3 per day