On the weekend Daylight Saving Time begin. Since then all of our reports have been coming in an hour later, the VBR server time has changed to Daylight Saving Time.
I am guessing VBR has been coded to use UTC/GMT. We run approx 50 schedules and are adding more all the time, so manually changing them every six months is not ideal in our situation.
1. Has anyone else experienced this at all?
2. Is there an easier way I could change these, maybe via SQL Query or something?
VBR uses the time of the server it's installed onto. If you are having issues with the server's implementation of daylight savings time, that's an issue for your SAs. =)
If your VBR server is in a different timezone than the Masters it reports on, then I can see how it'd be a little annoying, but as you said, unless you want to change them every 6 months, you're probably better off educating your users to expect the time shift. Or have them find a middle ground that works regardless of DST.