Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Creating a job with DBMS_SCHEDULER
I'll give the auto_drop => FALSE a try. Thx^2- rahno
- Post #5
- Forum: Oracle: All versions
-
Creating a job with DBMS_SCHEDULER
The long version is: our plan is to call the job from within an Oracle stored proc by jdbc from another server. Our java guy doesn't have a way to call an OS script on the Oracle box from the other box, but he can call an Oracle stored proc. The whole process is to insert data to the Oracle DB...- rahno
- Post #3
- Forum: Oracle: All versions
-
Creating a job with DBMS_SCHEDULER
We have Oracle 10g 10.2.0 Enterprise Edition on a Redhat Linux box. I am trying to run a bash shell script via a job that will run immediately once only. I entered the following in SQL+ after connecting as SYS/password AS SYSDBA. The PL/SQL block was executed without error. However, when I...- rahno
- Thread
- Replies: 4
- Forum: Oracle: All versions
