Automate Oracle SQL Developer script


I would like to know if it is possible to automate a script in the Oracle database manager.

What happens is that I have to run 3 lines or queries, every day. And I would like to know if there is a way to make automated.

The queries are 3 select, that is, I only consult some data to see the status.

asked by mijares93 03.01.2017 в 18:05

1 answer


It occurs to me:

  • create a store procedure with the logic of your select
  • create a job that executes the store procedure
  • regarding the data query you can do it in different ways: schedule tasks, send emails, through your application show a select etc.
  • answered by 28.12.2018 в 16:02