SQL & PL/SQL

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!

Job down and alert for DBA

703283Jul 6 2009 — edited Jul 7 2009

Hi all,

Is there any function in oracle can use to identify when the dbms_job is not running completely (I can only use dbms_job)? When the job is fail (maybe server down), I need oracle to sent an email to Database admin, but when the job is success, it should output into an I/O log file show that what time the job start run and what time the job finish run

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 4 2009

Added on Jul 6 2009

5 comments

674 views