Yesterday, I have altered the schedule for an event to run every 12 instead of every 24 hours. The original start time was 23:40, and I left that unchanged. So only the EVERY clause was changed.
Now I notice that the event has not run today at 11:40 (as I had expected), and the next scheduled time (as given by select db_extended_property('NextScheduleTime', 'MyEvent')) is tonight.
Does it mean that when using a period < 24 hours, I have to specify the first start time for the according day, since there's no automatic "day-overflow" calculation?
I.e. would I have to change my schedule to
start time '11:40' every 12 hours
to have it run twice a day?
asked 09 Jun '11, 09:35
Well, I should have read the docs, sigh...
So, yes, it seems that there's no automatic day-overflow calculation, and I have to ALTER the start time as well:)
answered 09 Jun '11, 10:04