Running a script at specified runtime
Home > IT Answers > Microsoft Windows > Running a script at specified runtime
Columbus
0 pts.
0
Q:
Running a script at specified runtime
Installation, Migration, Windows, Security, Oracle, SQL, Architecture/Design, Oracle administration, Performance/Tuning, E-Business Suite, Availability, Oracle Business Applications, Business Intelligence, Data/Application Integration, Oracle development, Oracle Database Versions, Backup & recovery, Oracle 9i
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
ASKED: Jul 10 2006  12:23 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
l902suedoe
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Jul 11 2006  10:59 AM GMT by l902suedoe   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0