Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to view Oracle job logs

mohitanchliaDec 17 2008 — edited Apr 22 2009
Oracle 10g:

I have following job:

procedure create_or_replace_job as
begin
begin
dbms_scheduler.drop_job(job_name => merge_job_name);
exception
when others then
/* ignore */
commit;
end;
dbms_scheduler.create_job(job_name => merge_job_name,
job_type => 'STORED_PROCEDURE',
job_action => merge_proc_name,
start_date => to_timestamp('01-Jan-1970 ' || merge_job_time,
'DD-Mon-RRRR HH24:MI:SS'),
repeat_interval => 'FREQ = DAILY; INTERVAL = 1');
commit;
end;
---

But I want to see when job ran and if there were any errors.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 20 2009
Added on Dec 17 2008
20 comments
61,742 views