Hello, I am trying to automate some of my reporting process and I am having trouble automating the data gathering part (i,e running the query). I am using sQL developer 12.1, on windows 7. This is a work computer and I believe I do not have admin rights.
I tried using SQLPlus and was able to connect properly; however, I it threw an error when I ran the script because one of my defined variables is over 240 characters long. if possible, I would not want to adjust my script because it is large and complex.
I tried using powershell (which I am not familiar at all), and I am having trouble even getting it to work. Once I downloaded ODP and googled a generic script to try, It asks for a TNS file which I can't find, so I do not know if powershell will be an option.
I looked at dBMS scheduler, but I could not find anything online that mentions how to schedule it to run a query.
my query is already set up with the spool command, so once I run it as a script, it will export my data to a csv file. from there, I can use VBA to auto grab and refresh the data.
I just do not know how to automate the query.
thoughts?
thank you