You could try a DTS package on a schedual as well. You can build the query in to the package and run it as often as you want.