How can I ensure that a dbms_scheduler job will never have more than one instance running?
For example, if I have a job that is scheduled to run once a minute, but it actually runs for three minutes, I don't want a second and third instance of the job to start and run concurrently.
(note) I previously asked this question specifying that either dbms_scheduler or dbms_jobs solutions were acceptable. I have since learned that dbms_jobs does not work well on RAC, hence this dbms_scheduler-specific question. (end note)