-
problems using DBMS_JOB
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|