Hi, I am using DBMS_JOB for the first time. I created a DBMS_JOB. This job is runs everyday at 6 AM. This job executes INSERT INTO SELECT FROM .

When this job ran at 6 AM, it failed because insert statements failed with primary key constraint. Since this run failed, its trying repeatedly after random duration. Is there any way we can stop executing this job repeatedly?

Please help
Thanks
Sandeep