Home > IT Answers > Oracle > Running a script at specified runtime
Help

Question

  Asked: Jul 10 2006   12:23 AM GMT
  Asked by: Columbus

Running a script at specified runtime


Oracle, Windows, Oracle administration, Architecture/Design, Availability, Backup & recovery, Installation, Migration, Performance/Tuning, Security, Oracle Business Applications, Business Intelligence, Data/Application Integration, E-Business Suite, Oracle Database Versions, Oracle 9i, Oracle development, SQL

I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime?

Thanks

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jul 11 2006  10:59 AM GMT  by l902suedoe




Hi Columbus.

The DBMS_JOB package should do the trick. See documentation on Oracle Supplied PL/SQL Packages and Types Reference for details on parameter requirements.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/jobq.htm#9499
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle, Microsoft Windows and DataCenter.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register