5 Replies Latest reply on Feb 6, 2012 8:59 AM by satish.lx

    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...