Sample Header Ad - 728x90

Prevent Subscription to report from running on a holiday

2 votes
1 answer
1078 views
I have a SQL Server that I am using for building and distributing reports. I have built all the packages for importing data as needed as SSIS packages. These reports only need to be run after the data has been imported. I have built my SSIS packages to check and make sure that the day isn't a holiday by comparing the date to a table that contains holidays. This way my data is only imported on business days. The problem is, my report subscriptions are set to run at a specific time Monday - Friday. How can I programmatically run the subscription at the end of my import, so that it only runs on the days that the import runs and not on the holidays?
Asked by JamesTheDev (155 rep)
Dec 4, 2014, 09:15 PM
Last activity: Dec 4, 2014, 09:24 PM