SSRS and Daylight Saving Time

• Scott Arendt

  SSCrazy Eights

  Points: 8218

  More actions

  October 26, 2010 at 9:36 am

  #240293

  With Daylight Saving Time coming up, I need to handle the offsets by running an update to the schedules in SQL Agent. Last spring, we only had our proprietary system to worry about and I have a script that manages the change each spring and fall.

  Since last spring, we have introduced SSRS into our systems. I was able to quickly determine which schedules in SQL Agent are related to SSRS, but I also noticed that the description is "This job is owned by a report server process. Modifying this job could result in database incompatibilities. Use Report Manager or Management Studio to update this job."

  Some research confirms the concerns with modifications, but they seem to be related to the name of the job, not the schedule.

  So, my question is, are there any concerns with updating the schedule programmatically? I use the existing sproc sp_update_schedule as follows:

  EXEC msdb.dbo.sp_update_schedule @schedule_id = @ScheduleID, @active_start_date = @NextRunDate, @active_start_time = @NextRunTime