Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

executing external sql script via dbms_scheduler

fzdevDec 15 2006 — edited Dec 16 2006

Is it possible to execute an external sql script via dbms_scheduler.

I have a bat job in the windows scheduler which executes the following command:
sqlplus -S user/pwd @script.sql

I want to move the scheduling of this script into the database utilising dbms_scheduler. Is there any way of issuing an @script.sql command from within dbms_scheduler

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 13 2007

Added on Dec 15 2006

#general-database-discussions

7 comments

2,942 views