I just set up a scheduled job to run overnight. Actually I set up several jobs each with it's own set of queries. It met my needs. When I asked the question I was just curious if there was some magical way of doing it I wasn't aware of and I am now confident the answer is no not really. Just do it outside of working hours so when it makes everything slow no one is around to notice.