johnnie d wrote:add new line at the bottom of the ETL script to invoke the shell script
I have a shell script which I want to call after running an ETL Script from a non-superuser account.
What is the quickest way of doing this using DBMS_SCHEDULER ? I have created a task in the scheduler accessible from OEM, but how do I run it programmatically ? The documentation I find to be a bit poor.
johnnie d wrote:Thank you for sharing
I was having problems with the linux configuration.
DBMS_SHEDULER.run_job was failing with "STANDARD_ERROR="Launching external job failed: Invalid username or password"
It was solved by adding the link in /lib64
# ln -s libpam.so.0 libpam.so
Edited by: johnnie d on 07-Dec-2012 12:07