Skip to Main Content
Forums

Enterprise Manager

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!

OEM job : How to force job status after a PLSQL job run?

odabovalFeb 26 2008 — edited Apr 21 2008
Hello,

We are under 10gR2, using OEM with a lot of jobs that call PLSQL procedures.

For some obscur reason, when a PLSQL procedure fails, the job status is always "Succeeded". This is not useful at all !!!

So, as we don't kow why, I was thinking about setting the return job status in the PLSQL procedure itself ...

Is it possible ?
How can I do that ?

I hope that my explanation is clear.

Thanks for your help,
Olivier
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2008
Added on Feb 26 2008
7 comments
2,120 views