Database Software

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.

DBMS_job error capture

MunishMay 5 2010 — edited May 6 2010

Hi,

I am running a scheduled job using dbms_job in oracle 8i.
Everything was working fine, then all of sudden 2 weeks ago job failed.
The following is what I did, hopefully someone can shed some light on it,

1. Run the job manually and it runs successfully
2. Run the job using dbms_job.run(9) and the job runs successfully
3. Put the job on a scheduler by using dbms_job.submit, the job says fails without giving any error..

I know some error is happening but how do you trap an error when job is getting run by dbms_job.submit.

Any help will be appreciated.

Thanks
Munish

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 3 2010

Added on May 5 2010

#database-key-features, #scheduler

3 comments

1,463 views