Ran into a case where report creator had created a report (non-unique file names) that updated to a fileshare every 15 mins. If the file was kept open by a user, job output would fail and be set to retry in 15 mins.
By default, RS maxretries=3 which means RS will try again 3 times before giving up. This was causing issue where these timed subscriptions were blocking each other from being successful. Ie. job runs, tries to save to file, but fails and will retry in 15 mins, but 15 mins later a new iteration of the job runs, tries to save to file, but that one fails as well and will retry in 15 mins, etc...
Resolved by setting Maxretries=0 so that if output fails, RS will NOT retry and next iteration of the job will have a chance to update the file.
Reference:
http://technet.microsoft.com/en-us/library/ms157273.aspx
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment