February 18, 2009 at 8:36 am
I am trying to set-up a subscription that runs every hour on a weekday between the hours of 0800-1700. I can only see a setting to either run the job once a day on a weekday or run the job every hour 24/7. I need a combination of these subscription schedules.
Only way I can see round the problem is to:
A) set-up seperate subscriptions that run @ 0800, 0900, 1000 etc
B) set-up an hourly shared schedule that I start at the beginning of the day and pause at the end of the day.
I do not have the Enterprise version as I thought I could maybe specify the subscription in a data driven subscription.
February 18, 2009 at 8:42 am
have you looked at the available stored procedures? you may be able to write some code to do exactly what you want using replication related sp's.
February 18, 2009 at 9:27 am
Thanks Thomas I'll take a look...was hoping for something simpler as I can't believe I'm the only person who would like to run a similiar task.
............ended up setting up seperate subscriptions for each hourly report..took about 30 mins to set everything up. In the end, thought it would be quicker than looking at other options.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply