Server: Oracle RAC 11.2.0.3.0
OS: RH Linux 6.8
SQL Developer Version: 4.1.0.17
Question: I run a query in SQL Developer manually every Friday, next I save the results to CSV file, next I import CSV into Excel sheet, next I email that sheet to several recipients.
1 - Is there a way to create a job on SQL Developer that will run this query, convert into CSV and email the results?
What I have done so far: In SQL Developer, I right clicked Scheduler --> right click jobs-->Created a job, using most of the following article.
But I never receive the results in my email.
Job attributes:
Enabled= Checked
Job Class: Sys.Default_Job_Class
Type of Job: PL/SQL Block
When to Execute Job: Repeating
Destination: Local
Notification: Recipients: My email address
Sender: My email address
Select Events: All of them
SQL Query: I copied and pasted right below Type of Job column.
Thanks for your help.
Article:
https://docs.oracle.com/cd/E55747_01/doc.41/e58244/GUID-E6812A89-197A-4515-82EF-4B26C05741EA.htm