Skip to Main Content

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!

Stop job with force called by user: 'SYS'

618868Jan 21 2008 — edited Jan 22 2008
Hello,

I created a job that will run every hour. The job starts a chain that have 2 simple steps that perform some cleanup. This will run as expected most of the time. But from time to time, one step will be stopped, canceling any action of the chain.

In such a case, I have the ADDITIONAL_INFO field for the stopped step in the SYS.ALL_SCHEDULER_JOB_LOG has: "Stop job with force called by user: 'SYS'"

After that, the job is rescheduled properly for the next hour.

This is happening on Oracle 10g XE.

Any clue is welcome.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2008
Added on Jan 21 2008
4 comments
4,251 views