SQL schedule query

Hello All,

I have a very complex SQL query and it will create some temp tables, insert data and manipulate etc.. as per i know report writer is just view only tool, Its not made for insert data and create tables stuff like that..

So my question is how do i run some custom query out of report writer and store that data in some temp tables and later i will retrieve them from report writer?  is orion has any inbuilt tool where i can run my SQL code or schedule them for every month, years etc...