March 25, 2008 at 10:28 am
I am wanting to update the SQL Server Agent job schedule, using a sproc, and have the online Report Server schedule reflect the updated schedule. I have been unsuccessful at finding information on this topic. I was thinking maybe updating the job using sp_update_jobschedule would update both, but that was not the case. I tried updating the ReportServer..Schedule table but the change was not reflected online or the agent job schedule.
Any advise is welcome. Thanks.
March 25, 2008 at 2:52 pm
Has anyone tried to do this? Any advise would be appreciated.
March 26, 2008 at 4:15 pm
I finally figured out the relationship between the sql agent job schedule and the Report Server online schedule. To reflect the change online you have to update the ReportServer..Subscriptions MatchData column with the new date and time, as well as update the ReportServer..Schedule Startdate column.
If anyone is trying to figure this out, hopefully this helps.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply