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

Improve this question
2
  • Were you able to find the answer for this? I would like do the same as well. Commented Oct 2, 2017 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 Commented Oct 2, 2018 at 9:03

1 Answer 1

Reset to default
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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.