I am using dbms_job.submit() to schedule a procedureusing the below statements.
sys.dbms_job.submit(job => v_job, what=>'execute_load();',
next_date =>to_date('23-04-2009 09:55:00','DD-MM-YYYY HH:MI:SS'), interval=> 'sysdate+ 1');
I want to get the output spooled to a log file every time when the job is being executed. So that I can find out if any error happened during the execution of the job.
My procedure is like:
Create or replace procedure execute_load is
v_SourceName VARCHAR2(15) :='ORACLE';
Please suggest what changes I need to do in the procedure to get the output spooled to the logfile. Or if there is some other way to generate the log file.
Thanks in advance
[Updated on: Sun, 31 May 2009 09:26] by Moderator
Report message to a moderator