Test fire alert schedule for 9pm every night?

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.

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.