Seeking Oracle Tools to Schedule SQL scripts
Posted on 2012-03-16
I am currently running Oracle EE 10.2.0.5.0 on Sun OS 5.10 Sun box and need a tool to schedule SQL script jobs to run against the database at night, weekly, monthly and quarterly. I want then the output to save automatically to csv or txt and possibly PDF. I am spending too much time trying to run reports after hours when I know there must be something out there that will allow me to automate this process and allow me to get some sleep. If possible, I can then securely email and/or SFTP the output file as well. Any ideas, thoughts or suggestions? I would run this tool from my Windows workstation or server. I am basically looking for a solution to do all of the above with minimal human intervention.
I need this right away.