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!

dbms_scheduler - how to stop a job in next run

Dba_SureshSSep 11 2010 — edited Sep 11 2010

HI All,

I have scheduled a job to run every 20 mins. Its a collection of procedures. During business hours, the scheduled job runs more than 1 hour because of this next cycle will be in queue, Once this cycle completes next wil be triggered in micro seconds.

I need to stop this JOb after completing the current cycle. I tried stop_job. I failed. Also I am not able to find the Job in scheduled state, due to above conditions. Its always in running state. I dont want to stop the current cycle forefully.

Maintenance window is running, I need to stop the Job after it completes current run.

Is it possible ? Can some one help me to achieve this.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2010

Added on Sep 11 2010

#database, #general-database-discussions, #oracle

7 comments

2,958 views