Home > IT Answers > DataCenter > Running a script at specified runtime
Columbus
0 pts.
 Running a script at specified runtime
Architecture/Design, Availability, Backup & recovery, Business Intelligence, Data/Application Integration, E-Business Suite, Installation, Migration, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows
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

Software/Hardware used:
ASKED: July 10, 2006  12:23 PM
UPDATED: July 11, 2006  10:59 AM
RELATED QUESTIONS
Answer Wiki:
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
Last Wiki Answer Submitted:  July 11, 2006  10:59 am  by  L902suedoe   0 pts.
All Answer Wiki Contributors:  L902suedoe   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _