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!

how to get the output on an external job.

user3903566Jun 6 2016 — edited Jun 8 2016

i got an Oracle Database 12.1.0.2.0 running on an Exadata server,

i have some scripts on my database server and i want to call them from Oracle and get the output

So i have followed step by step the manual https://docs.oracle.com/database/121/ADMIN/scheduse.htm#ADMIN12392 (Example 29-8 Creating a Local External Job and Viewing the Job Output) :

the job ran fine but i have nothing in output/additional_info

SELECT job_name, status, error#, errors, output, additional_info FROM dba_scheduler_job_run_details WHERE job_name = 'LSDIR';

=> LSDIR; SUCCEEDED;0;null,null;null

Any idea what's wrong?

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2016

Added on Jun 6 2016

#general-database-discussions

8 comments

1,701 views