This discussion is archived
1 Reply Latest reply: Dec 21, 2012 12:02 AM by Marwim RSS

Timer - Run .sql Script automatically

981098 Newbie
Currently Being Moderated
How do I setup an .sql script setup in SQL Developer to run automatically as a scheduled task?

thanks
  • 1. Re: Timer - Run .sql Script automatically
    Marwim Expert
    Currently Being Moderated
    Hello,

    welcome to the forum.

    SQL Developer is not a tool that can be automated. When you need to execute a script automatically, then you have several options.
    - Execute the script via SQL*PLUS, scheduled from OS
    - Use the db scheduler to execute a procedure
    - Call a OS script from a db job.

    For further information about these options go to {forum:id=193}, {forum:id=144} or {forum:id=75}.

    Regards
    Marcus

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points