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!

limit runtime of a JOB

25447Jun 19 2007 — edited Sep 2 2008

create a job, job_scan
run the job_scan
works great.

Can I tell job_scan to STOP_JOB, FORCE=TRUE after so many minutes in an attribute? I could not find it..

I can write ANOTHER job to monitor what JOBS are running, and if it job_scan runs over XX minutes, then DBMS_SCHEDULER.stop_job('xxx',TRUE);

Thx

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2008

Added on Jun 19 2007

#database-key-features, #job, #scheduler, #time

25 comments

32,049 views