Sunday, February 19, 2012

Execution Schedule

I have a Reporting Services report which is scheduled to execute on using snapshot on a 3-month cycle, on the 15th of Feb, May, Aug and Nov. This report was originally programmed to execute monthly on the 15th so we just changed the same schedule to execute choosing only Feb, May, Aug. and Nov but it executed on March 15. Shouldn't this have change it, would i need to create a new schedule and delete the old one?

If I were you, I would double check your schedule through Report Manager, then go check the SQL Agent Job. You have to make sure you hit Apply to the frequency and Ok on the Execution. Anyway, if both of those still show the correct schedule, try to delete it and re-create a new one.

Jarret

No comments:

Post a Comment