3

I have created a script to automate data extraction and saved in the location: C:\Users\Jeni\Desktop\Status.sql

And I call the script manually from Oracle Sql Developer by running the command

@C:\Users\Jeni\Desktop\Status.sql as a script

How can I automate the script to run daily from oracle sql developer

Lura Jeni Rajan
  • 61
  • 2
  • 9
  • Were you able to find the answer for this? I would like do the same as well. – Saqib Ali Oct 02 '17 at 17:05
  • Connections/[Your db]/Scheduler/Schedules Create a schedule. Then Connections/[Your db]/Scheduler/Jobs create a job and link it to your schedule – W_O_L_F Oct 02 '18 at 09:03

1 Answers1

1

Assuming that status.sql extracts your data to the database server, convert status.sql into a stored procedure and schedule it to run daily. This thread on Ask Tom is a great starting point.

Ernest Li
  • 118
  • 1
  • 8