How can a DBMS_JOB mark itself as broken?

Question

I want to run an update on a large list of rows in batches of 1000 rows. When putting the update statement inside some periodically executed DBMS_JOB is there a way for the job to suspend itself after the number of affected rows becomes zero?

Can a job find out its own job ID so it can call DBMS_JOB.Broken()?

Answer 1

select JOB from all_jobs
where what like '%YOUR_JOB_PROCEDURE%';

Also, I recommend to use DBMS_SCHEDULER instead of DBMS_JOB, if it is also available in your Oracle version http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_sched.htm