Hi,
As per my suggestions you should create a SSIS package( BY TAKING A SQL TASK) in which you write direct your sql or put stored proc if want. finally just schedule the package what time you what to execute the Query. Looking forward you feedback on my ans on your question.
Same suggestion I gave you still i would like to tell you how to do this task.
You can create SSIS package by following steps.
#1:- From Sql Server BI, just drag and drop the execute sql task and set the properties like you can set which stored procedure you want to execute.
Once you create the package it needs to configure with SQL Agent.
Go through the link to do that.
http://technet.microsoft.com/en-us/sqlserver/Video/ff686764.
looking forward for your feedback.
Thanks
Pradeep Gupta